Registered aircraft · 47,133

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.

N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248 N4648SKoehn Danny · Montezuma, KSBuilt 1975 · S/N E-767 N4649BNicholson Stephen G · Bayfield, COBuilt 1955 · S/N 31547 N4649EStanberry Carl W · Anchorage, AKS/N 18503830 N4649UMy Holdings Inc · Anchorage, AKBuilt 1979 · S/N U20605028 N464ACBlack River Company LLC · Memphis, TNS/N 1816 N464AGMagnum Management Corp · Pleasant Grove, UTBuilt 2006 · S/N 41574 N464CDSr-2x Aircraft LLC · Fort Worth, TXS/N 1495 N464EABaron Four LLC · Virginia Beach, VABuilt 2012 · S/N TH-2349 N464GSHooper Mark · Elko, NVBuilt 1978 · S/N U20604744 N464KBStillwater Aviation LLC · Belmont, CABuilt 2018 · S/N 1786 N464MMeyer Brent · San Antonio, TXBuilt 2002 · S/N 0221 N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372 N464PCJordan Thomas Harvey III · Jasper, GABuilt 2004 · S/N 1208 N464RWilson Aaron I · Fairmont, WVS/N 18260464 N464VCraig Michael · Port Orchard, WAS/N TC-1028 N464WHInfinite Loop Aviation LLC · Granite Bay, CABuilt 2019 · S/N 1928 N4650BByrne Robert R · Cameron Park, CABuilt 1955 · S/N 31548 N4650SMeno Brian P · Collinwood, TNBuilt 1975 · S/N TC-1907 N4651BGlenbear LLC · Kalispell, MTBuilt 1970 · S/N D-9157 N4651NSuemac Farms LLC · Crawfordsville, ARS/N 18267284 N4651SScranton Christian · Walnut Creek, CABuilt 1975 · S/N E-766 N4651TUnited Indian Missions Inc DBA · Tucson, AZBuilt 1979 · S/N U20605255 N46524Barry Mark K · Larimore, NDBuilt 1974 · S/N 18052424 N46535Rugged View Aviation LLC · Condon, MTBuilt 1974 · S/N 18052425 N4653AKuzina Ronald E · Wasilla, AKBuilt 1956 · S/N 32250 N4653KEastern Aviation Publishing Inc · Center Harbor, NHBuilt 1976 · S/N R1722004 N4653Q53 Quebec LLC · El Dorado, CABuilt 1972 · S/N 21059553 N4654AZerbinos Nicholas J · Anchorage, AKBuilt 1956 · S/N 32251 N4654KHoffman Matthew A · Baltimore, MDBuilt 1975 · S/N 18263656 N4654MJetway LLC · Dover, DEBuilt 2005 · S/N 29-0370 N4654QStapleton Mark Christopher · Vestavia Hills, ALBuilt 1972 · S/N 21059554 N4655AMasten Kirk E · Roanoke, INBuilt 1956 · S/N 32252 N4655EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268255 N46563Stephen Iain D · Anchorage, AKBuilt 1974 · S/N 18052427 N4656FCrowley Thomas Bannon III · Tigard, ORBuilt 1966 · S/N P206-0256 N4656KValley Agriculture LLC · Galt, CABuilt 1979 · S/N P21000251 N4657ATessos Air Service Inc · Wilmington, DES/N TH-41 N4657BBeam Gregory E · Anchorage, AKBuilt 1955 · S/N 31555 N4657FDoxsee Arthur B · Bennington, VTS/N P206-0257 N4658ALerner Michael M · Tehachapi, CABuilt 1956 · S/N 32255 N4658FSedrel Steven M · Sparks, NVBuilt 1966 · S/N P206-0258 N465AMN465am LLC · Hollis, NHBuilt 1981 · S/N 21064613 N465CGApogee Air LLC · Newark, CABuilt 1974 · S/N 18262873 N465CPN465cp Partners LLC · Sugar Land, TXBuilt 2008 · S/N 3279 N465CTMatter Terrence K · Reno, NVBuilt 1963 · S/N 18254800 N465CWSkyking LLC · Lake Stevens, WABuilt 1963 · S/N 310H0134 N465DLKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 310R1622 N465HDCorporate Air Services Inc · Salt Lake City, UTBuilt 2009 · S/N 411147 N465HMMorse Don W DBA · Priest Lake, IDS/N 50394

Back to AD 2000-23-21