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.

N950PLlbb Air LLC · Amarillo, TXBuilt 1998 · S/N 525-0234 N950PCGlobal Empire Trust LLC · Fort Lauderdale, FLBuilt 1996 · S/N 258300 N953FAffordable Equity Partners Inc · Columbia, MOBuilt 1989 · S/N 560-0005 N955TXLouis Jean LLC · Andrews, TXBuilt 2000 · S/N 525-0386 N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328 N957ECBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 146 N958GBHawkeye Asset Management & Consulting Services LLC · Kilgore, TXBuilt 2004 · S/N 560-0680 N958GCAj2 LLC · Arroyo Grande, CABuilt 2002 · S/N 550-1016 N958MGMgi Air Inc · Dubuque, IABuilt 2013 · S/N 525-0805 N959HMJavelina Aviation LLC · Cheyenne, WYBuilt 1993 · S/N 525-0047 N959JJJesus Saves LLC · Conroe, TXBuilt 1981 · S/N 319 N959RJ550rj LLC · Middletown, DES/N 550-0201 N95ANGrp Inc · Sanford, NCBuilt 2001 · S/N 550-0978 N95DTDtt Holdings LLC · Kalispell, MTBuilt 2021 · S/N 525-1099 N95PWOptions Strategy Services LLC · Sheridan, WYBuilt 2002 · S/N 550-1018 N95SSDeuce Aviation LLC · Valley Mills, TXBuilt 1999 · S/N 560-0509 N95TDMahato Enterprises LLC · Boca Raton, FLBuilt 1991 · S/N 560-0110 N95UPOehmig Aviation LLC · Chattanooga, TNS/N 258639 N962JKcb Industries LLC · Camden, DEBuilt 1982 · S/N 550-0453 N962KCD & D Aviation Inc · Olathe, KSBuilt 2004 · S/N 560-0670 N963DWWenta Nip & Sanitizing LLC · Monte Vista, COBuilt 1993 · S/N 5250033 N963SMNydam Scott A · Newport News, VAS/N D-1289 N964CNational Test Pilot School · Mojave, CABuilt 1981 · S/N 465-66 N965BSRgb Enterprises LLC · Garner, NCBuilt 2008 · S/N 560-0793 N966BBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 525-0966 N968ABN968ab LLC · Southfield, MIBuilt 1997 · S/N 258315 N968SRChrysler Aviation Inc · Van Nuys, CAS/N 560-0414 N969PAdams Dirk L · Pleasant Hill, OHBuilt 1947 · S/N D-71 N96BLBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 560-0342 N96GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 606 N96PZDwd Aviation LLC · Jacksonville, FLBuilt 2016 · S/N 525-0938 N970MMF/90 LLC · Montrose, COBuilt 2026 · S/N 525-1416 N971MBAdjacent Air LLC · Holdrege, NEBuilt 2017 · S/N 525-0971 N974AJHix Aviation LLC · Norman, OKBuilt 1996 · S/N 5600349 N975RGRg Aviation LLC · Fort Lauderdale, FLS/N 471 N976GACypress Aircraft Sales LLC · Clermont, FLBuilt 1980 · S/N 5500165 N976WTMcl Partners Lp · Stockton, CABuilt 1991 · S/N 560-0115 N977AVSecopsa Services LLC · Wilmington, DEBuilt 2001 · S/N 258559 N977DMDfm III LLC · Cortland, NYBuilt 1998 · S/N 560-0494 N977DTTomlin Don E · Midland, TXBuilt 2008 · S/N 560-0781 N977MRN977mr LLC · Pagosa Springs, COBuilt 2002 · S/N 560-0623 N978MAN978ma LLC · Eaton, COBuilt 2005 · S/N 560-0683 N979PWFlight By Pwi LLC · Nappanee, INBuilt 2004 · S/N 560-0650 N979RFJedami Air LLC · Southwest Ranches, FLBuilt 1981 · S/N 376 N979TX11 Niner Aviation LLC · Wilmington, DEBuilt 2017 · S/N 525-0979 N979WCTech 15 Air LLC · Seeley Lake, MTBuilt 1988 · S/N 550-0584 N97BHTs72 Management LLC · Wilson, WYS/N 560-0290 N97CLC2 Beach St Holdings II LLC · Ormond Beach, FLBuilt 1992 · S/N 560-0173 N97JABelt Tech Aero LLC · Washington, INBuilt 2022 · S/N 525-1113 N97SKL & L Aviation LLC · Bossier City, LABuilt 1998 · S/N 525-0290

Back to AD 97-05-03 R1