Registered aircraft · 2,862

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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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.

N81RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 472 N81VNChromed In Hollywood Inc · Franklin, TNBuilt 1989 · S/N 652 N820JTRegistered aircraftBuilt 2015 · S/N 525-0870 N820MCMontana 8083 Leasing Co LLC · Kalispell, MTS/N 550-0106 N821CDJ & B Quick Air LLC · Overland Park, KSBuilt 2016 · S/N 525-0922 N821LBTvpx Ars Inc Trustee · Concord, MAS/N 258650 N822JAWings Of Justice LLC · Bozeman, MTBuilt 2021 · S/N 525-1094 N822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 258643 N822TBOrscm2 LLC · Upland, CABuilt 2022 · S/N 525-1110 N823AMAirmed International LLC · Birmingham, ALBuilt 2004 · S/N 258687 N823CBThunderbird Equipment LLC · Hillsboro Beach, FLBuilt 2006 · S/N 560-0697 N823PMHernco Gp LLC · Fort Worth, TXBuilt 2003 · S/N 550-1064 N824CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 124 N825LJRoyal Air Freight Inc · Waterford, MIBuilt 1983 · S/N 496 N825MT376sb LLC · Lexington, KYBuilt 2014 · S/N 525-0825 N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497 N825SBTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1968 · S/N 282-92 N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025 N826ACTwin City Jets LLC · Wilmington, DEBuilt 1993 · S/N 560-0242 N826GCMqe LLC · Missoula, MTBuilt 1994 · S/N 258263 N826LMXuno Aviation LLC · Fort Lauderdale, FLBuilt 2019 · S/N 525-1046 N8288RFw Cielo LLC · Canton, OHBuilt 1999 · S/N 525-0348 N828AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 415 N828BGSweet Seasons Aviation LLC · Pharr, TXBuilt 1992 · S/N 550-0716 N829BCBerry Companies Inc · Wichita, KSBuilt 2017 · S/N 525-0951 N829CBN829cb LLC · Amarillo, TXBuilt 1998 · S/N 550-0829 N829TWTwhiskey Aviation LLC · Lawton, OKBuilt 1991 · S/N 550-0682 N82AEMain Street Logistics LLC · Hoover, ALBuilt 2000 · S/N 525-0412 N82BDU-Haul Business Consultants Inc · Phoenix, AZBuilt 2013 · S/N 525-0801 N82MLJltbm Investments Inc · Park City, UTBuilt 1982 · S/N 550-0408 N82RSFly Mda Aviation LLC · Opa Locka, FLBuilt 1997 · S/N 258336 N830DFNella Next LLC · Auburn, CABuilt 2022 · S/N 525-1125 N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222 N830JBCalcutta Air LLC · Dover, DEBuilt 1992 · S/N 560-0164 N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510 N832WDDodson International Parts Inc · Rantoul, KSS/N 190 N833JPEpic Aviation Inc · New Smyrna Beach, FLS/N 550-0315 N8341CAir Commander LLC · Woodbury, MNS/N 525-0150 N8344MAerotrust Services Corp Trustee · Wilmington, DEBuilt 1988 · S/N 550-0577 N835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 673 N837PFSoutheastern Red Holdings LLC · Wellington, FLBuilt 2018 · S/N 525-1010 N838BBE D Santos & Associates LLC · Wilmington, DES/N 258301 N83EPRegistered aircraftBuilt 1989 · S/N 5600021 N83HAFly My Ultra LLC · Sellersburg, INS/N 5600487 N83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 288 N83ZAOp Partner Inc · Odessa, TXBuilt 1992 · S/N 5600176 N840AAD And S Western Holdings LLC · Garden City, TXBuilt 1997 · S/N 560-0433 N840CTKeith Hammett LLC · Missoula, MTBuilt 1993 · S/N 560-0236 N840PMCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 2004 · S/N 525-0541 N841TFRoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 416

Back to AD 97-05-03 R1