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.

N808NANasa Neil A Armstrong Flight Research Center · Edwards, CABuilt 1984 · S/N 424 N809TSMedic Choppers LLC · Springdale, ARS/N D-809 N80AB80ab Group LLC · Wichita Falls, TXBuilt 1992 · S/N 560-0169 N80JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 560-0327 N80PGPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 063 N80PKN80080pk LLC · Stuart, FLBuilt 1999 · S/N 258442 N80PTCb80pt LLC · Stuart, FLBuilt 1998 · S/N 550-0839 N80YBYork Aircraft Equities LLC · York, PABuilt 2024 · S/N 525-1183 N810AFJt Acquisitions LLC · Nashville, TNBuilt 2002 · S/N 258589 N810BEChrysler Aviation Inc · Van Nuys, CABuilt 1990 · S/N 560-0066 N810SSNgo Aviation LLC · Lafayette, LABuilt 1996 · S/N 525-0137 N811JANature Coast Aviation LLC · Homosassa, FLBuilt 2000 · S/N 550-0952 N811JLSolera Aviation LLC · Bozeman, MTBuilt 2021 · S/N 525-1090 N811SH1212012 LLC · Omaha, NEBuilt 1991 · S/N 560-0120 N811WEWarmont Company · Midland, TXBuilt 2011 · S/N 560-0811 N812LLH800 Vi LLC · Stuart, FLBuilt 2003 · S/N 258620 N812MEBig Blue Sky Aviation Co · Midland, TXBuilt 2002 · S/N 550-1023 N812SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 258683 N812SHCamp Logistics LLC · Scottsdale, AZBuilt 1990 · S/N 560-0049 N813FMKevin Parra Aviation LLC · San Diego, CABuilt 2015 · S/N 525-0884 N813JDApple Air LLC · Tieton, WABuilt 1998 · S/N 550-0838 N813RERichmond 135 LLC · Norwalk, CTBuilt 2008 · S/N 560-0799 N813SHN813sh LLC · Omaha, NEBuilt 1995 · S/N 560-0343 N814BRWinston Electric Inc · Lubbock, TXBuilt 1998 · S/N 5605003 N814DMSix Romeo Mike LLC · Billings, MTBuilt 2000 · S/N 525-0376 N814LG814 Lima Golf LLC · Fayetteville, ARS/N 525-0534 N814SHSilverhawk Aviation Inc · Lincoln, NEBuilt 1997 · S/N 5600405 N815CMAmerileasing Corp DBA · Cheyenne, WYBuilt 1991 · S/N 560-0104 N815MCEfficiency Aloft LLC · Santa Rosa, CABuilt 1996 · S/N 5250142 N816AXBrookfield Reliable LLC · Kansas City, MOBuilt 1999 · S/N 285 N816KYBcp Fa Ap LLC · Providence, RIBuilt 2004 · S/N 258680 N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291 N816LXEa Enterprises LLC · Bismarck, NDBuilt 1998 · S/N 258363 N816SHSilverhawk Aviation Inc · Lincoln, NEBuilt 1996 · S/N 560-0360 N817EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5058 N817EMCentennial Capital LLC · Centennial, COBuilt 1982 · S/N 486 N817HCHudson Air LLC · Henagar, ALBuilt 2001 · S/N 5250459 N817SDSea Aviation Holdings LLC · Wilmington, DEBuilt 2005 · S/N 258709 N817SHTilt Up Travels LLC · Norfolk, NEBuilt 1995 · S/N 560-0318 N818BFStarlight Aviation LLC · Harvey, LABuilt 1995 · S/N 560-0317 N818FC609jr LLC · Bozeman, MTBuilt 1994 · S/N 525-0059 N818LXN818lx LLC · Wilmington, DEBuilt 2001 · S/N 258534 N818RUWorldwide Alliance Air LLC · Ocala, FLBuilt 1997 · S/N 560-0443 N818SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2001 · S/N 560-0581 N818VBPhoenix Air Group Inc · Cartersville, GABuilt 1980 · S/N 302 N819EXPreserve Air LLC · Honolulu, HIBuilt 2006 · S/N 347 N819KRPrestige Worldwide Flights LLC · Imperial, CABuilt 1979 · S/N 550-0114 N819SCHb4 LLC · Las Vegas, NVBuilt 1997 · S/N 550-0818 N819SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2002 · S/N 560-0604 N81CP78cl Aviation LLC · Ogden, UTBuilt 2007 · S/N 525-0633

Back to AD 97-05-03 R1