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.

N782STBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLFirst renewal noticeBuilt 1991 · S/N 550-0679 N783DLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 525-1075 N785CWConstruction Solutions & Consulting LLC · Sedalia, MOBuilt 2000 · S/N 550-0916 N785PDOrchard Elms LLC · North Ogden, UTBuilt 2025 · S/N 525-1193 N7867THoldsworth David · Crystal City, TXBuilt 1989 · S/N 560-0020 N786MXMadix Inc · Terrell, TXBuilt 2008 · S/N 560-0786 N788JWNorth Fork Place LLC · Bozeman, MTBuilt 2020 · S/N 525-1050 N789HAClark County Jets LLC · Sellersburg, INBuilt 1998 · S/N 258354 N789JKJk Aircraft Options LLC · Aripeka, FLBuilt 1980 · S/N 5500116 N789JSArs Air LLC · Newport Beach, CABuilt 2008 · S/N 560-0801 N78MDValiar Ltd Co Trustee · Casper, WYBuilt 2001 · S/N 550-0970 N78TJKcs Aviation LLC · Columbia, TNBuilt 2015 · S/N 525-0864 N790JRTransenergie Inc · Houston, TXBuilt 1984 · S/N 424 N793BCFour Lee LLC · Jeffersonville, INBuilt 2007 · S/N 560-0758 N793CJAgl Lease LLC · Grand Rapids, MNBuilt 2000 · S/N 525-0021 N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550 N794PFPrestage Farms Of South Carolina LLC · Camden, SCBuilt 2007 · S/N 525-0649 N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228 N795JKN90tr LLC · Paso Robles, CABuilt 1978 · S/N 550-0027 N796MACypress Aircraft Sales LLC · Clermont, FLBuilt 2000 · S/N 550-0941 N797BKBlue Bird Of Happiness LLC · Shreveport, LABuilt 2018 · S/N 525-1001 N797MMNext Generation Aviation LLC · Beloit, WIBuilt 1990 · S/N 5600078 N797TEN797te LLC · Hermiston, ORBuilt 2001 · S/N 550-0962 N798JSLtn Aviation LLC · Draper, UTBuilt 2008 · S/N 560-0796 N799MWSabre 42 Inc · Lewes, DEBuilt 1980 · S/N 465-42 N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708 N799SN143bl LLC · Hixson, TNBuilt 2002 · S/N 258588 N79AJCal Avia LLC · Fresno, CABuilt 1999 · S/N 525-0321 N79CJV1vr LLC · Wilmington, DEBuilt 1981 · S/N 179 N79DAPahlisch Homes Inc · Bend, ORBuilt 1999 · S/N 550-0875 N79TSTasair LLC · Minocqua, WIBuilt 2001 · S/N 258511 N7CQEfc Aircraft LLC · Missoula, MTBuilt 1993 · S/N 525-0004 N7HJHessjet LLC · Mc Donald, TNBuilt 2001 · S/N 550-0983 N7KGTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1973 · S/N 282-111 N7MHFlying Hare LLC · High Point, NCBuilt 1994 · S/N 525-0081 N7YAVander Dussen Robert · Clovis, NMBuilt 1999 · S/N 550-0880 N800DTN800dt LLC · Wilmington, DEBuilt 1994 · S/N 525-0092 N800EASalt Whistle LLC · Newark, DEBuilt 2002 · S/N 258582 N800GNJaunt Jet LLC · Spring, TXBuilt 1998 · S/N 258372 N800LQAdc Aviation LLC · Birmingham, ALBuilt 2001 · S/N 258551 N800MAMarco Aviation LLC · Nazareth, PABuilt 1998 · S/N 258369 N800MTTarp-It Air LLC · Ellensburg, WABuilt 2001 · S/N 550-0981 N800NBN800nb LLC · Minneapolis, MNBuilt 1997 · S/N 525-0212 N800NGClear Horizons LLC · Greenwood Village, COBuilt 2001 · S/N 258549 N800NJGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 2000 · S/N 258483 N800PEFour C Air Inc · Delano, CABuilt 2000 · S/N 258508 N800PLN800pl LLC · Fort Lauderdale, FLS/N 258696 N800THHoover Aviation LLC · Nashville, TNBuilt 2004 · S/N 258678 N800TLN800tl LLC · Wilmington, DEBuilt 1998 · S/N 258394 N800UKJ W Construction Co Inc · Wise, VABuilt 2002 · S/N 258577

Back to AD 97-05-03 R1