Skip to content

Registered aircraft · 22,413

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N6410JNoggle George · Bucyrus, OHBuilt 1968 · S/N 28-4827 N6411CWilcoxen Mark A · Bargersville, INBuilt 1978 · S/N 28-7816421 N6411JPacific Union College · Angwin, CABuilt 1968 · S/N 28-4828 N6411WHis Promise Aviation Service · Big Spring, TXBuilt 1964 · S/N 28-20480 N6412WFlying Otter Aviation LLC · Snellville, GABuilt 1964 · S/N 28-20481 N6413RLee Dylan Robert · Portland, ORS/N 28-21592 N6414JEight Three Quebec LLC · Orange, CABuilt 1968 · S/N 28-4831 N6414RSommer Kelly L II · Galena, AKFirst renewal noticeBuilt 1966 · S/N 28-21593 N6414WOttos Aviation LLC · Kenosha, WIBuilt 1964 · S/N 28-20483 N6415JFalcon Air Co · Marina Del Rey, CABuilt 1968 · S/N 28-4832 N6415WMullins Tom H · W Alexandria, OHBuilt 1964 · S/N 28-20484 N6416JGallant Kenneth R · Beach Haven, NJBuilt 1968 · S/N 28-4833 N6416RNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 28-21595 N6417RBogey Aviation LLC · Piqua, OHS/N 28-21596 N6419JMathis Charles D · Carrollton, GABuilt 1968 · S/N 28-4836 N641BBJones Legal Holdings LLC · Pikeville, KYBuilt 1995 · S/N 3213101 N641CCClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890493 N641FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842318 N6420JPomerenke Tyler J · Fairmont, MNBuilt 1968 · S/N 28-4837 N6421JShoemaker Kent L · Renfrew, PABuilt 1968 · S/N 28-4839 N6421WTyde Arthur F III · Los Angeles, CAS/N 28-20491 N6422JSuncoast Aviators LLC · Odessa, FLBuilt 1968 · S/N 28-4840 N6422RYang Chi · Lafayette, COBuilt 1966 · S/N 28-21601 N6422WDomler Michael R · Gilroy, CABuilt 1964 · S/N 28-20492 N6423RBerkner Charles P · Milbank, SDBuilt 1966 · S/N 28-21602 N6424CBlock Howard M · Plymouth, CTBuilt 1978 · S/N 28R-7803230 N6424WCsapos Larry G · Ovid, MIBuilt 1964 · S/N 28-20494 N6425JPetrich Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 28-4843 N6426JMunz Dennis F · Prairie Du Chien, WIBuilt 1968 · S/N 28-4844 N6427RNortheast Texas Aviation LLC · Chandler, TXBuilt 1966 · S/N 28-21607 N6428JPhillips Roger Dale II · Westfield, NCBuilt 1968 · S/N 28-4846 N6428WGeraghty John T · Long Beach, CABuilt 1964 · S/N 28-20498 N6429WFarquharson Mark · Hampton, VABuilt 1964 · S/N 28-20499 N642CFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R8031155 N642FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 2842319 N642JAYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020142 N642JF6 Xt LLC · Fort Lauderdale, FLBuilt 2005 · S/N 3255040 N6431RCarothers Paul W · Russellville, ARBuilt 1966 · S/N 28-21611 N6432JPeri Joshua E · Orting, WABuilt 1968 · S/N 28-4850 N6432RBreitbarth Brian · Canby, ORS/N 28-21613 N6432WStoltzman Keith W · Amboy, MNBuilt 1964 · S/N 28-20502 N6433RGary R Kasper Motor Sales · Vassar, MIBuilt 1966 · S/N 28-21614 N6433WLipinski Glen E · Chandler, AZBuilt 1964 · S/N 28-20503 N6434WBlack Scorpion Nv LLC · Elko, NVBuilt 1964 · S/N 28-20504 N6435JRegistration Pending · Pocahontas, IARegistration pendingBuilt 1968 · S/N 28-4853 N6435RSpears Travis L · North Augusta, SCBuilt 1966 · S/N 28-21616 N6437JHolt Dalin · Gig Harbor, WABuilt 1968 · S/N 28-4854 N6437RMoyer Aviation Inc · Ulysses, KSBuilt 1966 · S/N 28-21618 N643FLGoudy Steven A · Wheatland, WYS/N 28-7125551 N643FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843703

Back to AD 87-08-08 R3