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.

N725JADans Flying Circus LLC · Danbury, CTBuilt 1993 · S/N 560-0205 N726HAAerojet USA LLC · Knox, INBuilt 1980 · S/N 550-0206 N726LCN726lc LLC · Amarillo, TXBuilt 1998 · S/N 258349 N726TMAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2001 · S/N 525-0414 N727SBEta Partners LLC · Bossier City, LABuilt 2018 · S/N 525-1006 N728CRCdsm 601 LLC · Opa Locka, FLBuilt 1980 · S/N 550-0159 N728TGDigital Interstate Management Inc · Keller, TXBuilt 1984 · S/N 420 N729ATN88ca III LLC · Stuart, FLBuilt 1999 · S/N 258402 N729WREiron Nadav Trustee · Portola Valley, CABuilt 2000 · S/N 525-0398 N72ACAlliance Service Inc · Lexington, KYBuilt 2007 · S/N 525-0643 N72AYCababie Sara · Laredo, TXBuilt 1981 · S/N 419 N72BTPhenom Partners LLC · Wilmington, DEBuilt 1999 · S/N 525-0306 N72FCAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258519 N72HAMcn Aviation Partners LLC · Charlestown, INBuilt 2000 · S/N 258503 N72JWTitle Financial Group LLC · Blackfoot, IDBuilt 2000 · S/N 525-0406 N730GYG&Y Airline LLC · Longview, TXBuilt 2019 · S/N 525-1016 N731DCSunshine Aviation LLC · Jackson, TNBuilt 2019 · S/N 525-1039 N731RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 328 N731TRSapphire Living Inc · West Linn, ORBuilt 1997 · S/N 560-0411 N732MTextron Aviation Inc · Wichita, KSBuilt 2008 · S/N 525-0685 N733GBuzick Air LLC · Bardstown, KYBuilt 2004 · S/N 340 N734DBN779at LLC · Punta Gorda, FLS/N 560-0143 N73CKKalitta Charters LLC · Ypsilanti, MIS/N 092 N73LRFalcon N73lr LLC · Belton, TXBuilt 1974 · S/N 35 N740RBSummit Capital Partners Aviation Services LLC · Houston, TXBuilt 2007 · S/N 560-0752 N740TTValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 258644 N741CCBlake Aviation Enterprises LLC · Fort Worth, TXBuilt 1997 · S/N 525-0227 N744ARTop Air Texas LLC · Glendale, CABuilt 2001 · S/N 316 N745MCMiradair LLC · Lake George, NYBuilt 2002 · S/N 258593 N746TXSierra Aviation Holdings LLC · Colorado Springs, COBuilt 2005 · S/N 258746 N747ACGoing Going Gone LLC · North Las Vegas, NVBuilt 1997 · S/N 525-0202 N747BWOxford LLC · Fort Lauderdale, FLBuilt 1984 · S/N 594 N747CPRoyal Air Charter LLC · El Cajon, CABuilt 1983 · S/N 502 N747HZLewis Aeronautical LLC · San Antonio, TXBuilt 2022 · S/N 525-1108 N748BL755 Holdings LLC · Tiffin, OHBuilt 2022 · S/N 525-1116 N748MNOnpoint Avionics LLC · Downey, CAFirst renewal noticeBuilt 1977 · S/N 215 N749TTHarpe Air LLC · Horseshoe Bay, TXBuilt 1994 · S/N 560-0248 N749WWSmf Ohio LLC · Lakewood, NJBuilt 2001 · S/N 258500 N74GRRobinson George A IV · Houston, TXBuilt 2006 · S/N 560-0704 N74KMCyd Aviation LLC · Austin, TXBuilt 2014 · S/N 525-0800 N74SCGreen Michael B · Kent, WAS/N D-432 N750FLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 560-0268 N750MLLincoln Industries Inc · Lincoln, NEBuilt 1994 · S/N 560-0247 N753GJWarhawk Aviation LLC · Baton Rouge, LABuilt 1995 · S/N 560-0306 N753MBSteel Diamond LLC · Sheridan, WYBuilt 1989 · S/N 560-0028 N757TRRegistered aircraftS/N 560-0598 N758SLGoldstein Investment Group LLC · Omaha, NES/N 550-0554 N75DHBrent Staggs Medical Consulting LLC · Little Rock, ARBuilt 1993 · S/N 560-0215 N75LTLaughing Giraffe Aviation LLC · Millsboro, DEBuilt 1998 · S/N 525-0241 N75TMMilazzo Holdings LLC · Wales, WIBuilt 1995 · S/N 560-0296

Back to AD 97-05-03 R1