Registered aircraft · 2,861

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.

N202LGLegacy 20 Enterprises LLC · Wilmington, DEBuilt 2000 · S/N 258454 N202PPTwin P Aviation LLC · Fort Worth, TXBuilt 2007 · S/N 560-0753 N202PXZ & L Consulting LLC · Midland, TXS/N 17 N203HSPbi Aviation LLC · Dallas, TXBuilt 1992 · S/N 5600203 N203NCC Aviation LLC · Maiden, NCBuilt 1990 · S/N 203 N204BGPrecision Aviation Inc · Kimberly, IDBuilt 1999 · S/N 560-0503 N204CFCorporate Flight Inc · Waterford, MIBuilt 1980 · S/N 550-0238 N204JCentral Beach LLC · El Paso, TXBuilt 1996 · S/N 525-0164 N204PMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 550-0320 N204WSPremier Aircraft LLC · East Alton, ILBuilt 1981 · S/N 181 N2057HCam Jet Aviation LLC · Lamesa, TXBuilt 1981 · S/N 550-0274 N205DJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 399 N205TCCarpenter Aviation LLC · Northport, ALBuilt 1994 · S/N 525-0050 N208AVTeton Leasing LLC · Pocatello, IDBuilt 1996 · S/N 560-0358 N208VPN771at LLC · Lewes, DES/N 560-0208 N209CV209cv LLC · Bozeman, MTBuilt 1993 · S/N 560-0209 N20CCGunnslinger Air LLC · Destin, FLBuilt 1998 · S/N 560-0467 N20DCKar Aviation LLC · New Albany, MSS/N 5250208 N20PJAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 258275 N20VLRusken Packaging Inc · Cullman, ALBuilt 1994 · S/N 525-0069 N20YTWoodbine Aviation LLC · Lewes, DES/N 550-0213 N210CMJet Way LLC · Brooklyn, OHBuilt 1996 · S/N 560-0369 N210MBSafe Flight LLC · Suwanee, GABuilt 1997 · S/N 525-0211 N211BRNational Test Pilot School · Mojave, CABuilt 1972 · S/N 282-99 N211ECEast Coast Flight Services Inc · Easton, MDBuilt 1980 · S/N 166 N211MTTrn Aviation LLC · Lewes, DEBuilt 1979 · S/N 550-0098 N212AGSea Aviation Holdings LLC · Wilmington, DEBuilt 2007 · S/N 258821 N212FJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 147 N212MRLeader Air Service Inc · Miami, FLS/N 550-0210 N212RHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 525-0636 N213JSN213js LLC · Lewes, DEBuilt 1989 · S/N 5500597 N213JTLake Air Sale LLC · Wilmington, DEBuilt 2002 · S/N 525-0492 N213SWSouthworth Aviation LLC · Memphis, TNBuilt 1996 · S/N 560-0363 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N214JTBig River Air LLC · Wilmington, DEBuilt 1982 · S/N 550-0418 N214TDHarbor Aircraft LLC · Wilmington, DEBuilt 1997 · S/N 258332 N2150HCove Pointe Air LLC · Adrian, MIBuilt 1977 · S/N 210 N217AJMontana Jet LLC · Monterey, CABuilt 2003 · S/N 560-0638 N217CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 217 N217GLBozzy Creek LLC · Frisco, TXBuilt 1990 · S/N 560-0076 N217SASprinter Trailer LLC · Winston, ORBuilt 1993 · S/N 550-0217 N217TAFox Aviation LLC · Santa Maria, CABuilt 1979 · S/N 289 N217THDouble I Enterprises LLC · Mcallen, TXBuilt 1996 · S/N 560-0390 N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489 N218RXAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 258323 N219HFAugusta Air II LLC · Fayetteville, NCBuilt 2016 · S/N 525-0907 N219MSPuerto Rico Air LLC · Winter Park, FLBuilt 1980 · S/N 550-0180 N219TAValle Aviation Inc · Nashville, GABuilt 2004 · S/N 560-0669 N21CVBlu Sky Aviation LLC · Georgetown, TXBuilt 1995 · S/N 560-0340

Back to AD 97-05-03 R1