Registered aircraft · 68,375

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

N31482First Flight Aero LLC · Reno, NVBuilt 1980 · S/N 2218 N31488Brewer Stephen F · Hamilton, OHBuilt 1940 · S/N L10960 N3148MThoft Matthew M · Wasilla, AKBuilt 1947 · S/N 12-1835 N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448 N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439 N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449 N314AKTremble Toby K · Wasilla, AKBuilt 2024 · S/N 1001 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314DBButler David Trustee · Palos Park, ILBuilt 2004 · S/N 921 N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828 N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226 N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391 N314LFEnalas Corp · Bayonne, NJBuilt 2004 · S/N 20-1027 N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010 N314MFGobel Victor M · White City, ORBuilt 2023 · S/N JA5980920 N314MZZemsta Mike · New Britain, CTBuilt 2019 · S/N 90454 N314PTStrong Thomas W · Rigby, IDBuilt 2006 · S/N 90489 N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031 N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98 N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314RVRegistered aircraftBuilt 2007 · S/N 802 N314SEZaludek Joseph S · Eugene, ORBuilt 2003 · S/N 40.328 N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114 N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314 N314SYDeas James A · Independence, ORBuilt 2013 · S/N 72973 N314TSSteele William G · Warrenton, VABuilt 2003 · S/N 80877 N314YOlson Allen J · Ludington, MIBuilt 1975 · S/N 69 N31504Gendron Matthew · Port Orange, FLS/N 7749 N3150WRegistration Pending · Olympia, WARegistration pendingBuilt 1979 · S/N VAC-126-79 N31519Aerobatics Unlimited · Utica, ILBuilt 1981 · S/N 2250 N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453 N3151MWrong Brothers Aviation LLC · Webster, MNBuilt 1947 · S/N 12-1837 N3151RBergstrom Danny · Stillwater, MNBuilt 1982 · S/N 353 N3151XJoseph Stern · Sherman, TXS/N 17702399 N3151ZOld Crow Flyers LLC · Mooresville, NCBuilt 1959 · S/N 22-7098 N31524Beazley Phillip B · Millbrook, ALBuilt 1994 · S/N 1 N3152MAce Aeromotive Inc · Miami, FLBuilt 1947 · S/N 12-1839 N3152ZMoultrie Zachariah D M · Grass Valley, CABuilt 1959 · S/N 22-7096 N31531Storey James F · Gadsden, ALBuilt 1978 · S/N 28-7816558 N31532Delaware Valley Aviation Inc · Langhorne, PABuilt 1978 · S/N 28-7890468 N3153HChristensen David R · Brigham Cit, UTBuilt 1982 · S/N 663 N3153TRegistered aircraftBuilt 1967 · S/N 17700453 N31543Scott Barry R · Florence, ALS/N 209 N3154MBurnett Martin · Greenbrier, ARBuilt 1947 · S/N 12-1841 N3155KCaldwell Skylar Franklin · Fort Collins, COBuilt 1998 · S/N KA-118 N3155MManrique Rick E · Palmer, AKFirst renewal noticeBuilt 1947 · S/N 12-1857 N3155SSterling Flight Training LLC · Jacksonville, FLBuilt 1978 · S/N 28-7890525

Back to AD 90-04-06 R1