OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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
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-01-01-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-01-01-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.

N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693N16DPNdmi Inc · Greeneville, TNS/N 24-3024N16EMB J Air Ltd · Howard, OHBuilt 1976 · S/N 32R-7680228N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675N16JSMace Terry G · Saint James, MNBuilt 1973 · S/N 28R-7335304N16NJBurke Bryan E · Broomfield, COBuilt 1969 · S/N 30-1845N16TWBaughman Kevin · Avinger, TXBuilt 1964 · S/N 30-527N1705MYeager Jacob M · Ignacio, COBuilt 1975 · S/N 28R-7535260N1707HCyberflight Inc · Wilmington, DEBuilt 1977 · S/N 28R-7737010N170TBIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350190N17123Wieszkowiak Thomas J · Sunbury, PABuilt 1976 · S/N 32R-7680327N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756N1723HCo-Operative Cross Roads Flying Club · Albuquerque, NMBuilt 1977 · S/N 32R-7780187N172NDBlue Max Aero LLC · Miles City, MTBuilt 1988 · S/N 2837007N1746H1746h LLC · La Mirada, CAS/N 28R-7737011N1747HRooks John S · Barrington, RIBuilt 1977 · S/N 28R-7703033N1750HDileo Steven · Gallatin, TNBuilt 1977 · S/N 32R-7780189N175MBKlein Robert · North Garden, VABuilt 1959 · S/N 24-721N175WWMassari Edward Sr · Mount Laurel, NJS/N 28R-7703074N1765HMcumber James W · Elkin, NCS/N 28R-7703034N176VTNewberg Andrew J · Clinton, ILBuilt 1976 · S/N 32R-7680279N1776URegistration Pending · Boulder City, NVRegistration pendingBuilt 1975 · S/N 32R-7680024N178EGagan Samrat LLC · Charlotte, NCS/N 30-1727N178UDavis Roger W · Felton, DEBuilt 1969 · S/N 30-1779N178XSs Aviation LLC · Sulphur, LAS/N 30-1950N1795HJp Kelly Air LLC · Fort Smith, ARBuilt 1977 · S/N 28R-7703035N17ARDer Kazarian Peter · Holden, MABuilt 1976 · S/N 32R-7780077N17BDRegistered aircraftBuilt 1967 · S/N 30-1520N17CMAbernathy Laurence K · Wills Point, TXBuilt 1964 · S/N 30-437N17CRDawn Aviation LLC · Pierce City, MOBuilt 1965 · S/N 24-4093N17FVStoltzfus Shawn D · Lancaster, PABuilt 1977 · S/N 28R-7737089N17MBAerocorp LLC · San Antonio, TXBuilt 1966 · S/N 30-1215N17TARetired Aviators Flying Club LLC · Oklahoma City, OKBuilt 1961 · S/N 24-2652N1805HIronworks Asset Resources LLC · Chesapeake, VABuilt 1977 · S/N 32R-7780191N1806HKessler Derek · Lexington, OKBuilt 1977 · S/N 32R-7780192N180CVN Registration Service LLC Trustee · Sanford, NCBuilt 1968 · S/N 28R30693N180MLBearden Harold H · Haleyville, ALBuilt 1961 · S/N 24-2609N181DP181dp Aircraft Leasing LLC · Spanish Fork, UTS/N 28R-7335246N181DWNorthern Aviation LLC · Palmer, AKS/N 32R-7680440N181FMLuse Otis · Lago Vista, TXS/N 34-7770400N1820TCallender Richard · Presque Isle, WIBuilt 1971 · S/N 28R-7135122N1839HFly 172n LLC · Peoria, AZBuilt 1977 · S/N 34-7770152N1861HElusive Aviation Inc · Pflugerville, TXBuilt 1977 · S/N 32R-7780195N1862HKaufman Keith · Reading, PABuilt 1977 · S/N 32R-7780196N1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 34-7770153N187SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 28R-7235139N188SPThornado Aviation LLC · Indialantic, FLBuilt 1977 · S/N 32R-7780309N189MLStrobe Aviation LLC · Columbia, SCBuilt 1977 · S/N 34-7770114N18FTSk Ventures LLC · Hamilton, MTBuilt 1976 · S/N 32-R-7780126
Back to AD 97-01-01 R1