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.

N75VCSunshine Aero Industries Inc · Crestview, FLBuilt 1981 · S/N 465-71 N75VKMaranatha Leasing & Consulting Inc · Marco Island, FLBuilt 2019 · S/N 525-1042 N75WPSalt River Project Agric Improvement & Power Dist · Phoenix, AZBuilt 1997 · S/N 560-0449 N7607BTechnical Education Services Inc · Virginia Beach, VABuilt 1947 · S/N D-854 N760ASNorsan Investors LLC · Concord, CABuilt 2007 · S/N 560-0760 N760MSurdex Corp · Chesterfield, MOBuilt 1990 · S/N 550-0635 N763PPTop Air Texas LLC · Glendale, CABuilt 1999 · S/N 278 N764JSAhw Aviation Inc · Anchorage, AKBuilt 2007 · S/N 560-0776 N765RDCitation 550-399 LLC · Lewes, DEBuilt 1981 · S/N 550-0399 N767KCBig Orange Sky LLC · Green Bay, WIBuilt 1999 · S/N 560-0517 N768JSSfh Inc DBA · Fargo, NDBuilt 2005 · S/N 560-0775 N769BBJ2s LLC · Benton, ARBuilt 2002 · S/N 550-1042 N76ASGs Ici Holdings LLC · Beaumont, TXS/N 5500432 N76CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 076 N76GPGp Flight Group LLC · Petaluma, CABuilt 2023 · S/N 525-1151 N76RARoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 35A-140 N76RBLe Norman Avion LLC · Oklahoma City, OKS/N 550-0871 N76TFFca LLC · Leawood, KSBuilt 1997 · S/N 560-0431 N76YTJack Straw Development LLC · Tempe, AZBuilt 2009 · S/N 525-0687 N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587 N770DSSpirit Of America Foundation Inc · Chattanooga, TNBuilt 1998 · S/N 5500862 N771FMCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2002 · S/N 258591 N771NHeitzman Gordon E · White Bear Lake, MNBuilt 1947 · S/N D-1082 N772CSH & D Aviation LLC · Smithfield, NCBuilt 2007 · S/N 560-0772 N772DCBest Aircraft Deals LLC · Salt Lake City, UTS/N 410 N772SBApex Air LLC · Dover, DEBuilt 1984 · S/N 550-0498 N773RBPymp LLC · Nashville, TNBuilt 1990 · S/N 560-0052 N774JTRegistration Pending · Springfield, MORegistration pendingBuilt 2020 · S/N 525-1065 N774MBVida Trade And Management Group · Charlotte, NCS/N 339 N774SBAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 560-0684 N775TBCj Partners LLC · Springfield, ILBuilt 1994 · S/N 525-0075 N776WRTwin Eagles Aviation Inc · Fort Mohave, AZBuilt 1998 · S/N 560-0459 N777BPFloss Five Ten LLC · Lewisville, NCBuilt 2018 · S/N 525-0986 N777HDButler Brian S · Oklahoma City, OKBuilt 1983 · S/N 397 N777JCPrimiani Maurizio · Great Falls, MTS/N D-685 N777WYGulf Atlantic Airways Inc · Gainesville, FLBuilt 1999 · S/N 560-0525 N778BValiair Lc Trustee · Casper, WYBuilt 1999 · S/N 560-0523 N778TBTrcc Inc · Visalia, CABuilt 2004 · S/N 550-1083 N779RKMcaire LLC · Newton, NCBuilt 2008 · S/N 560-0779 N77DBDarrigo Bros Co Of California · Salinas, CABuilt 2001 · S/N 525-0443 N77GUFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 46512 N77KNAlta Aviation LLC · Phoenix, AZBuilt 2014 · S/N 5250821 N77MAM Aire LLC · Wilmington, DEBuilt 1994 · S/N 560-0273 N77METrilogy Investments Ag LLC · Las Vegas, NVBuilt 1982 · S/N 96 N77PRTrns Solutions LLC · Lewes, DES/N 550-0211 N780ABEagle Wings Aviation LLC · Canton, MABuilt 1994 · S/N 525-0073 N780CBQuality Liquid Feeds Inc · Dodgeville, WIBuilt 2008 · S/N 560-0790 N780CFAlcyone Trust Corporation Trustee · Wichita, KSBuilt 1978 · S/N 550-0014 N780DCAllard Air Services Inc · Scottsdale, AZBuilt 2016 · S/N 525-0910 N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378

Back to AD 97-05-03 R1