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.

N97VFLynnco Airways LLC · Cleveland, TNBuilt 1996 · S/N 525-0171 N97XPE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1996 · S/N 258310 N980VPAircraft Partner Holdings Inc Trustee · Fallbrook, CAS/N 525-0098 N981AGInternational Aviation Sales Ltd · Cleveland, OHBuilt 1998 · S/N 560-0466 N981ALMalik Hassan · Richfield, OHBuilt 1978 · S/N 216 N981CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2002 · S/N 258563 N981DBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1996 · S/N 258302 N982NAParatus Jets LLC · Auburn, INBuilt 1982 · S/N 550-0345 N984LSBest Citation 2 LLC · N Canton, OHBuilt 2018 · S/N 525-0984 N985CLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 258490 N986PREdwards Air LLC · Paducah, KYBuilt 2015 · S/N 525-0886 N986SAN331us LLC · Hillsboro, ORBuilt 1985 · S/N 609 N987CFPeekey Lumbus LLC · Vista, CABuilt 2007 · S/N 351 N987CLHawker N981ce & N987ce LLC · Wilmington, DEBuilt 2001 · S/N 258557 N988QCMed Air LLC · Wilmington, DEBuilt 1981 · S/N 455 N988RSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 258598 N989ABJs Air Holdings LLC · Buckner, KYBuilt 2001 · S/N 550-0961 N989CLBoligee Air LLC · Birmingham, ALBuilt 2001 · S/N 258535 N989STSix Columns Aviation LLC · Dallas, TXBuilt 2000 · S/N 258478 N98ACPf Travel LLC · Encinitas, CABuilt 2002 · S/N 329 N98BMVs Maritime LLC · Oklahoma City, OKBuilt 1976 · S/N 193 N98HGN98hg LLC · Sheridan, WYBuilt 1983 · S/N 394 N99000Madras Trading Corp · New York, NYNon-citizen corporation, flight hours not reportedS/N 5600299 N990EVEncore Jet Management LLC · San Antonio, TXBuilt 1999 · S/N 258412 N990JHBluebird Opportunities LLC · Helena, MTBuilt 2007 · S/N 560-0754 N990LCAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1982 · S/N 483 N990MMenzil Enterprises Inc · West Mifflin, PANon-citizen corporation, flight hours not reportedBuilt 1989 · S/N 5500608 N990MRThree Amigos Citation II LLC · Jacksonville, FLBuilt 1983 · S/N 550-0488 N990TCJet Air Inc · Iowa City, IABuilt 2001 · S/N 550-0963 N9915ZWysteria LLC · Rock Island, ILBuilt 2002 · S/N 525-0504 N991FRAudaciter LLC · Fort Lauderdale, FLBuilt 2004 · S/N 258660 N991SRIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N 525-0295 N992CSSierra Bravo Aviation LLC · Harrison, ARBuilt 1982 · S/N 550-0363 N992NANational Aeronautics And Space Administration · Houston, TXBuilt 1980 · S/N 309 N993GLCody Aviation Partners LLC · Salt Lake City, UTBuilt 2003 · S/N 525-0509 N993SGHazel Aviation LLC · Mcdonough, GABuilt 1998 · S/N 258377 N994EAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N 460 N995DPAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1984 · S/N 600 N995JPAir Strong LLC · Mountain Brk, ALBuilt 1995 · S/N 560-0307 N996ACCf Holdings LLC · Hernando, MSBuilt 1990 · S/N 5500641 N996JRHutter Charles G · Carson City, NVBuilt 1996 · S/N 525-0147 N997EA5 Star Aviation LLC · Aurora, MOBuilt 1992 · S/N 560-0178 N997XJN997xj LLC · Dover, DES/N 550-1038 N998CMTango Kilo Enterprises Inc · Surfside, CABuilt 2018 · S/N 525-0998 N998EAVet Investments LLC · Essex, MTBuilt 1995 · S/N 560-0316 N998GBMoondance Aviation LLC · Merriam, KSBuilt 1999 · S/N 560-0507 N998RHDodson International Parts Inc · Rantoul, KSS/N 550-0957 N998SRRegistration Pending · Owensboro, KYRegistration pendingBuilt 2006 · S/N 550-1136 N998TSAm Aviation LLC · Everett, WABuilt 2001 · S/N 550-0987 N998TWEsw Enterprises Travel LLC · Dallas, TXBuilt 1996 · S/N 560-0362

Back to AD 97-05-03 R1