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.

N278WDSnk LLC · Reisterstown, MDBuilt 2011 · S/N 3825 N2790GBryan Roger J · Spearfish, SDBuilt 1959 · S/N 52090 N2790QArthur Lloyd T · Greenfield, INS/N 18257990 N2791GHoutte Edmund Michael DBA · Palmer, AKBuilt 1959 · S/N 52091 N2791TJoyce George E · Franklinville, NCS/N TE-384 N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892 N2792GSpeedstar Aviation LLC · Kalispell, MTBuilt 1959 · S/N 52092 N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542 N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992 N2793GMeyer Steven D · Snohomish, WABuilt 1959 · S/N 52093 N2793THaas Mark A · Ridgecrest, CABuilt 1967 · S/N D-8499 N2794GClark Jeremiah Jacob · Pleasant Plains, ARBuilt 1959 · S/N 52094 N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546 N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994 N2795FRegistration Pending · Marietta, GARegistration pendingBuilt 1966 · S/N 18256895 N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896 N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096 N2796TPozdolski Casey · Los Osos, CABuilt 1967 · S/N D-8491 N2797ABlue Line Aviation LLC · Vidalia, GABuilt 1969 · S/N D-9055 N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897 N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555 N2797TD'Angelo Brothers Development LLC · Helena, MTBuilt 1967 · S/N D-8486 N2798FGoodall Maurice M II · Omak, WABuilt 1966 · S/N 18256898 N2798GBremerton City Flying Club · Poulsbo, WABuilt 1959 · S/N 52098 N2798TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1967 · S/N D-8488 N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598 N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099 N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592 N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599 N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822 N279CPBarnard Henry H III · Albany, GABuilt 2008 · S/N 3221 N279CWPapas Plane LLC · Ashland, NEBuilt 2019 · S/N 2004 N279JLJml Aviation LLC · Berwyn, PABuilt 2025 · S/N 10729 N279JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2259 N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499 N279MTGmcm Aviation LLC · Central, SCBuilt 2007 · S/N 2470 N279PSCirrus Design Corp · Duluth, MNBuilt 2023 · S/N 9215 N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347 N279SVGeorge W Goodknight Inc · Chattanooga, OKBuilt 1979 · S/N 79-30939 N279TXHester Air LLC · Visalia, CAS/N 0877 N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826 N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108 N27BGGuzman Steven Manuel · Port Saint Lucie, FLS/N 340A0656 N27CTClinic-Air Aviation · Chapmansboro, TNBuilt 1979 · S/N 33701888 N27DHMcavoy Sean M · Greenbrier, TNBuilt 1970 · S/N D-9149 N27DJLiberty Air LLC · Sarasota, FLBuilt 2019 · S/N 1959 N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228 N27EBWalker Co · Cody, WYBuilt 2008 · S/N L2K 138 N27EMStair Colin · Brookfield, WIBuilt 2006 · S/N 1798 N27FCWalburn John M · Mansfield, OHBuilt 1962 · S/N 18254410

Back to AD 2000-23-21