Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544 N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644 N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437 N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145 N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545 N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645 N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505 N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145 N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246 N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146 N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546 N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546 N3146WWalker Ernest F · Bala Cynwyd, PABuilt 1973 · S/N CE-479 N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946 N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882 N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147 N3147WTadesco Rothchild LLC · Wilmington, DEBuilt 1973 · S/N D-9569 N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947 N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945 N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548 N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648 N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148 N31494Locker Aircraft Inc · Muleshoe, TXBuilt 1988 · S/N CE-1269 N31497N400sr LLC · Astoria, NYBuilt 1988 · S/N CE-1275 N314AAlien Air LLC · Missoula, MTBuilt 2006 · S/N 2061 N314ATBerlin Airlift Historical Foundation · Farmingdale, NJBuilt 1968 · S/N 337-1047 N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547 N314CPWilbury LLC · Las Vegas, NVBuilt 2008 · S/N 3234 N314DBrantley Hugh Lawton · Hazlehurst, GABuilt 1965 · S/N 320C-0067 N314DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1975 · S/N 34-7570285 N314DGLaminar Holdings LLC · Sheridan, WYBuilt 2007 · S/N 260 N314DSFlyers Unlimited LLC · Tucson, AZBuilt 2005 · S/N 1705 N314EBRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1981 · S/N 25-0591 N314GFrownfelter Grant M · Fenton, MIBuilt 2006 · S/N 314 N314HBMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1586 N314KD314 Aviation LLC · Carlisle, PABuilt 2024 · S/N 10165 N314KFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2456 N314MPTeristar LLC · Lewes, DEBuilt 1958 · S/N 51634 N314NFWillis Charlotte Y · Belleview, FLBuilt 1960 · S/N 52548 N314PKKelsey Excavating Inc · Davis, ILBuilt 2006 · S/N 1779 N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879 N314RDMeyer Ronnie G · Sidney, NEBuilt 2006 · S/N 1648 N314SOrem John Marshall · Shallowater, TXBuilt 1956 · S/N 33981 N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457 N314UPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1979 · S/N 310R1852 N314XRoss Peter W Trustee · Lufkin, TXBuilt 1975 · S/N 6134C N314YFOcana Investments LLC · Hendersonville, TNBuilt 2015 · S/N 2302 N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948 N3150LS & S Aircraft Inc · El Dorado, ARBuilt 1965 · S/N 310J0150 N3151DVan Aero LLC · Dover, DEBuilt 1955 · S/N 31949

Back to AD 2000-23-21