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.

N8RLDumbo Enterprises LLC · West Hartford, CTBuilt 2001 · S/N 525-0429 N900BBNical Aviation LLC · Austin, TXBuilt 1999 · S/N 284 N900DMMwm Air LLC · Adrian, MIBuilt 1981 · S/N 358 N900DSOwens Aviation Inc · Dallas, TXBuilt 1993 · S/N 525-0032 N900EN900e LLC · Lewes, DEBuilt 1993 · S/N 560-0206 N900GFShb-Cb LLC · Shreveport, LABuilt 2003 · S/N 550-1046 N900MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 525-1126 N900PBFlb Group LLC · Knoxville, TNBuilt 1988 · S/N 550-0566 N900PSAero Air Charter Holding LLC · Pensacola, FLBuilt 1991 · S/N 560-0118 N901ABAngel Brothers Enterprises Ltd · Baytown, TXBuilt 1995 · S/N 560-0302 N901GGLong Bay Partners LLC · Missoula, MTBuilt 2015 · S/N 525-0901 N901JWThunderbolt Transport Inc · Memphis, TNBuilt 2022 · S/N 525-1123 N901LBNwl Capital Holdings LLC · Black Eagle, MTS/N 560-0218 N901SCSc Aviation Inc · Monroe, WIBuilt 2001 · S/N 258561 N902ABAngel Brothers Enterprises Ltd · Baytown, TXBuilt 2000 · S/N 298 N903GWPro Water Solutions LLC · Henderson, TXBuilt 2008 · S/N 525-0676 N904BBMmw Aviation LLC · Chesapeake, VABuilt 2000 · S/N 550-0904 N904GWCobb Industrial Inc · Holly Springs, GABuilt 2008 · S/N 525-0681 N904JJetran LLC · Horseshoe Bay, TXBuilt 1991 · S/N 560-0144 N904LRChrysler Aviation Inc · Van Nuys, CABuilt 1992 · S/N 560-0163 N904MACjd Air Inc · Sanford, FLBuilt 2005 · S/N 550-1104 N904SJA&M Aviation LLC · Irondale, ALBuilt 1989 · S/N 5500604 N905GSGlh Capital LLC · Pittsfield, MABuilt 2023 · S/N 525-1137 N905GWN905gw LLC · Lake Park, GABuilt 2008 · S/N 525-0682 N905LCLoraine LLC · Wilmington, DEBuilt 1995 · S/N 560-0334 N905MHScranton Christian · Walnut Creek, CABuilt 1982 · S/N 550-0454 N906ASSpencer Air LLC · Tucson, AZBuilt 2002 · S/N 258569 N906RRHill Country Restaurants Inc · Nacogdoches, TXBuilt 2016 · S/N 525-0906 N906WGClbs Equipment LLC · Prosper, TXBuilt 2022 · S/N 525-1122 N907ASBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N E2156 N907DKAbsolute Aviation LLC · Dayton, OHBuilt 1999 · S/N 525-0338 N907GWPnc Bank Na · Boise, IDBuilt 2018 · S/N 525-1011 N907MCTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1997 · S/N 258340 N908ASBank Of Utah Trustee · Salt Lake City, UTS/N E2082 N908GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1140 N908PRCitation 908 LLC · Chattanooga, TNS/N 525-0148 N908TFSkyview LLC · Wilmington, DES/N 102 N908WTPrice James E · Reno, NVS/N D-926 N909ACAirchoice LLC · Manchester, IABuilt 1999 · S/N 258404 N909DJCitation N909dj LLC · Palm Beach Gardens, FLBuilt 1993 · S/N 560-0214 N909DPCook Childrens Health Enterprises · Fort Worth, TXBuilt 2002 · S/N 525-0503 N909GWJoe Morten & Son Inc · South Sioux City, NEBuilt 2023 · S/N 525-1142 N909HTAmd-Kls LLC · Sevierville, TNBuilt 2000 · S/N 525-0382 N909JMRegistered aircraftBuilt 2000 · S/N 304 N909LBNtbb LLC · Henderson, NVBuilt 1999 · S/N 560-0519 N909MWilmington Trust Co Trustee · Wilmington, DEBuilt 1998 · S/N 525-0249 N909SFSayum LLC · Gonzales, CABuilt 1990 · S/N 550-0630 N909YR909 Aero LLC · Phoenix, AZBuilt 1999 · S/N 525-0339 N90DBDura-Built Of Delaware LLC · Lewes, DEBuilt 2018 · S/N 525-1005 N90FBLitton Global LLC · Wilmington, DEBuilt 2003 · S/N 258613

Back to AD 97-05-03 R1