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.

N178ZLUsda Forest Service Fepp · Columbia, SCBuilt 1963 · S/N 18254850 N1790RBlack Dog Holding Inc · Pleasant Valley, NYS/N 18502506 N1791ESol Aerial Surveys LLC · Las Vegas, NVBuilt 1979 · S/N 310R1576 N1791GPac Flying LLC · Saint Johns, FLBuilt 1962 · S/N CD-514 N1791MA & S Helicopters Inc · Cahokia, ILBuilt 1971 · S/N 33701391 N1792GHelminiak Jon · Milwaukee, WIBuilt 1962 · S/N D-6976 N1792REcho Matrix LLC · Bentonville, ARBuilt 1974 · S/N 18502508 N17931Unlimited Sky LLC · Swansboro, NCBuilt 1977 · S/N E-1022 N1793GGeorgen Auto LLC · Manchester, IAS/N CD-515 N1794CAcp Aviation LLC · Oakdale, LABuilt 1953 · S/N 30494 N1794MSkyriders Flying Club Inc · Aurora, COBuilt 1975 · S/N 18264447 N1794WSkyhawk Flying Club Inc · Omaha, NEBuilt 1972 · S/N E-380 N1794XGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 21060814 N1795CSchellhaas Bennett · Galloway, OHBuilt 1953 · S/N 30495 N1795ERb Aviation LLC · Tyler, TXBuilt 1979 · S/N 310R1577 N1795GProps2jets LLC · Bolingbrook, ILBuilt 1962 · S/N D-6977 N1795HJp Kelly Air LLC · Fort Smith, ARBuilt 1977 · S/N 28R-7703035 N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511 N1796GHorowitch Alan · San Diego, CABuilt 1975 · S/N 310R0048 N17979Alford Flying LLC · Wichita, KSBuilt 1977 · S/N TH-832 N1797CKelley Larry D · Portland, ORBuilt 1953 · S/N 30497 N1797GTabor Tobey R · Ventura, CABuilt 1962 · S/N D-6975 N1797MCp & R Transport LLC · Grace, IDBuilt 1975 · S/N 18264450 N1797RNorthstar Holdings LLC · Anchorage, AKBuilt 1981 · S/N U20606331 N1797XN1797x Aero LLC · Gulf Breeze, FLBuilt 1975 · S/N 21060817 N1797ZReal Fly Air Service LLC · Jackson, WYBuilt 1963 · S/N 336-0097 N17980Rowles Robert · Pittsfield, ILBuilt 1977 · S/N TH-840 N1798GMeaux Jimmie J Jr · Kaplan, LABuilt 1962 · S/N CD-512 N1798MWalker Steven C · Lake Havasu City, AZBuilt 1975 · S/N 18264451 N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514 N1798XN1798x LLC · Etna Green, INBuilt 1975 · S/N 21060818 N1798ZCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11602 N1799ZWanderlove Alaska LLC · Anchorage, AKBuilt 1963 · S/N 336-0099 N179AKCrp Research LLC · Fenton, MIBuilt 2017 · S/N E-4101 N179CDBravo Aviation LLC · Newburgh, INBuilt 2000 · S/N 1081 N179JDFarnborough Aircraft Inc Trustee · Wilmington, DEBuilt 2017 · S/N 1527 N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519 N179MCFulton Rick D · Marble Falls, TXBuilt 1990 · S/N CE-1530 N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179 N179TWBlue Sky Aviation Investments LLC · Coconut Creek, FLBuilt 1979 · S/N 79-30957 N179WSEbken Gary R · Loxahatchee, FLBuilt 1959 · S/N 51698 N179WZCatterton Jane S · Signal Mountain, TNBuilt 1981 · S/N 18268036 N179XPLadonne Frank · Fort Collins, COBuilt 1979 · S/N R1723155 N17ABBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 21057674 N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524 N17AXWard Hugh W · Arlington, TXBuilt 1979 · S/N 28R-7931132 N17BHFoster Brian J · Mancelona, MIBuilt 1972 · S/N 18261384 N17BPTeam Yak Attack Inc · Poplar Grove, ILBuilt 1974 · S/N TC-1650 N17BRJds Management Co LLC · Warner Robins, GABuilt 1983 · S/N TH-1372 N17CBCygnet Aerospace Corp · Los Osos, CABuilt 1966 · S/N D-8232

Back to AD 2000-23-21