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.

N570DMAb Monterrey Aircraft LLC · San Antonio, TXBuilt 1994 · S/N 525-0055 N571APOreilly II Aviation Corp · Springfield, MOBuilt 2011 · S/N 560-0805 N571GTConrad Aviation LLC · Forest Hill, LABuilt 2021 · S/N 525-1089 N572RSB2b Aviation LLC · Leesburg, VAS/N 525-1421 N5734N5734 LLC · Katy, TXBuilt 1997 · S/N 258304 N573CMFlightline Holdings LLC · New Orelans, LABuilt 1999 · S/N 525-0352 N573MBohlke LLC · Kingshill, VIBuilt 2003 · S/N 550-1066 N574TATango Alpha Management Co LLC · Georgetown, SCBuilt 2026 · S/N 525-1406 N575CFChestnut Aviation LLC · Lewes, DEBuilt 1990 · S/N 560-0079 N575MGAntelope Valley Community College District · Lancaster, CAS/N 550-0450 N575TMHauck Enterprises Ltd · Port Neches, TXBuilt 2014 · S/N 525-0838 N576PVHamilton Victor · Jupiter, FLBuilt 1982 · S/N 383 N577BBB And K Aircraft Holdings LLC · North Canton, OHBuilt 1997 · S/N 550-0826 N577KPPelican Sky LLC · Abbeville, LABuilt 2000 · S/N 525-0389 N577MCUltraa Air LLC · Lafayette, CABuilt 1998 · S/N 550-0861 N577RWBlue South Adventures LLC · Westlake, TXBuilt 1997 · S/N 560-0434 N577XWJetreed LLC · Mount Pleasant, SCBuilt 1990 · S/N 560-0083 N578CFInfinity Aviation LLC · Mandan, NDBuilt 2017 · S/N 525-0965 N578RLValiair Limited Co Trustee · Casper, WYBuilt 1999 · S/N 258397 N579BJCurly LLC · Santa Maria, CABuilt 1996 · S/N 560-0383 N579DLee David · Palm Springs, CAS/N D-369 N579MJet Air Inc · Galesburg, ILBuilt 2006 · S/N 550-1133 N579TXLaw Offices Of Douglas D Ketterman Pllc · San Antonio, TXBuilt 1994 · S/N 525-0061 N57ECSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 2001 · S/N 525-0460 N57FWilliams John E · Oak Ridge, TNBuilt 1948 · S/N D-1273 N57VYEuroaviation Inc Trustee · KematenS/N 525-0371 N580BDAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1997 · S/N 525-0209 N580CLBravo Ventures LLC · Reedsburg, WIBuilt 2008 · S/N 560-0780 N580ZTaft Enterprises LLC · Wilmington, DEBuilt 2008 · S/N 525-0672 N583TL518mv Air LLC · Modesto, CABuilt 2001 · S/N 560-0583 N584PSGilco Enterprises LLC · Benbrook, TXBuilt 1998 · S/N 550-0847 N5852KBode Aviation Inc · Albuquerque, NMBuilt 2003 · S/N 550-1056 N585FDWoodbine Aviation LLC · Lewes, DEBuilt 1992 · S/N 560-0113 N585KSSaai.Com LLC · Miami, FLBuilt 2000 · S/N 550-0945 N585KTSadler Trevor Trustee · ProvidencialesNon-citizen corporation, flight hours not reportedS/N 550-0420 N585MCStuart Nathan · Saint Augustine, FLS/N 525-0452 N585MLBh Transportation LLC · Jackson, TNBuilt 2000 · S/N 525-0402 N585VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258585 N588ACBlu Bird Consulting Services LLC · Burnet, TXBuilt 2000 · S/N 550-0912 N588FPJk Aircraft Options LLC · Aripeka, FLS/N 550-0228 N588JKJk Aircraft Options LLC · Saint Petersburg, FLBuilt 1988 · S/N 550-0570 N589FPJk Aircraft Options LLC · Aripeka, FLBuilt 1981 · S/N 550-0337 N589HHAccelgf Inc · Reno, NVBuilt 2002 · S/N 550-1005 N58CWOn Eagles Wings I LLC · Pearland, TXBuilt 1977 · S/N 116 N58DRocketman Rocketeers Lc · Austin, TXBuilt 2005 · S/N 560-0690 N58DHAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2002 · S/N 258599 N58ERPersonnel Aviation Services LLC · Bloomfield Hills, MIBuilt 2023 · S/N 525-1157 N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279 N58HTAmerican Air Charter Inc · Chesterfield, MOBuilt 1981 · S/N 465-70 N58SGZetroz Systems LLC · Trumbull, CTBuilt 2026 · S/N 525-1403

Back to AD 97-05-03 R1