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.

N590AKt Aviation LLC · Las Cruces, NMBuilt 1989 · S/N 560-0029 N590FPJk Aircraft Options LLC · Aripeka, FLS/N 5600087 N591DKIron Ring Aviation LLC · Portland, ORBuilt 2001 · S/N 560-0591 N591MMFantasy Flight LLC · Atlanta, GABuilt 1999 · S/N 525-0330 N592FPJk Aircraft Options LLC · Aripeka, FLBuilt 2001 · S/N 550-0974 N592MABg LLC · Bozeman, MTBuilt 1996 · S/N 560-0372 N592VPKracum Laura T Trustee · Miami, FLS/N 560-0092A N593FPJk Aircraft Options LLC · Hernando Beach, FLBuilt 2002 · S/N 550-1010 N593WTSabin Lake Aviation LLC · Rogers, MNBuilt 2014 · S/N 525-0839 N594FPJk Aircraft Options LLC · Hernando Beach, FLBuilt 2001 · S/N 550-1004 N594WPGolden Leaf Tobacco Company Inc · Keysville, VABuilt 1992 · S/N 550-0693 N595KWGeronimo Aviation LLC · Burlison, TNBuilt 2002 · S/N 560-0595 N595PDRegistration Pending · Camden, DERegistration pendingBuilt 2001 · S/N 258526 N595RMAntelope Valley Community College District · Lancaster, CABuilt 1979 · S/N 550-0061 N599KDEncore One LLC · Conway, ARBuilt 2007 · S/N 560-0755 N59BSSlx Air LLC · Waxhaw, NCBuilt 1996 · S/N 525-0169 N59DFRlc Partners LLC · Grand Prairie, TXBuilt 1991 · S/N 560-0098 N59FHSpecialty Air Partners LLC · Mooresville, NCBuilt 1995 · S/N 525-0105 N59YPNextgen Flying LLC · The Villages, FLBuilt 1998 · S/N 275 N5AFCavu Charters LLC · Stuart, FLBuilt 2023 · S/N 525-1145 N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187 N5UUFlid Aviation LLC · Birmingham, ALBuilt 1998 · S/N 560-0457 N5WCMidstar Transport LLC · Midland, TXBuilt 1997 · S/N 5600403 N5WTShell Air LLC · Liberty Township, OHBuilt 2003 · S/N 560-0635 N600ALShobers Equipment LLC · Bedford, PABuilt 2000 · S/N 525-0383 N600ATHarlow Cattle LLC · Dallas, TXBuilt 1987 · S/N 550-0551 N600BWLambert Mcguire Management LLC · Austin, TXBuilt 2004 · S/N 560-0671 N600CDKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 377 N600GKAerospace Trust Management LLC · Wilmington, DEBuilt 1998 · S/N 525-0297 N600HRLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1993 · S/N 525-0038 N600HWSafe Adventures LLC · North Miami, FLBuilt 1983 · S/N 5500479 N600JBOgden Aviation LLC · Hinsdale, ILBuilt 1998 · S/N 272 N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416 N600LYMajjec Jhett LLC · Springfield, MABuilt 2004 · S/N 337 N600NYNxjets.Net LLC · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 231 N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296 N600TBFleet Aircorp Inc · Fort Lauderdale, FLS/N 550-0154 N600VMLeisure Time Properties Inc · Ardmore, OKBuilt 2013 · S/N 525-0804 N600XTEubel Brady & Suttman Asset Management Inc · Miamisburg, OHBuilt 2009 · S/N 525-0375 N601BCAir Prive Solutions LLC · Miami Beach, FLBuilt 1979 · S/N 550-0091 N601CBCj1 LLC · Carmel, INBuilt 2002 · S/N 550-1014 N602ATOdl Partners LLC · Oklahoma City, OKS/N 550-0606 N602JVFull Scale Jets LLC · Idaho Falls, IDBuilt 2020 · S/N 525-1064 N603AWNational Test Pilot School · Mojave, CABuilt 1981 · S/N 46572 N603CDWtc Pitts LLC · Coushatta, LABuilt 2019 · S/N 525-1029 N603DWOnarco2 LLC · Maurice, IABuilt 2005 · S/N 550-1109 N604GSSix Hundred Four Corp · Paramus, NJS/N 604 N604PJJere Aviation LLC · Fond Du Lac, WIBuilt 1983 · S/N 550-0459 N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202 N605JYN524ma Inc · Wilmington, DEBuilt 1978 · S/N 550-0029

Back to AD 97-05-03 R1