OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,130

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:2009-13-06-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:2009-13-06-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.

N979SPGulf South Services LLC · Chipley, FLS/N 31-7812015N97MADodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7552006N97NNAviation Business Corp · Saint Louis, MOS/N 23-435N980CATlh Enterprises Inc · Corsicana, TXBuilt 1980 · S/N 31T-8104010N982KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 31T-7820011N98FAHigher Purpose Aviaiton LLC · Spring Lake, MIBuilt 1980 · S/N 31T-8004028N98PPMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 27-2872N98TGBell Scott W · Greeley, COS/N 31T-7904027N9901Noiw Resources LLC · Belle Chasse, LABuilt 1981 · S/N 318152168N990LRDavis Aviation Inc · Brandon, MSBuilt 1978 · S/N 31T7820060N992Baker Duke I · Jackson, MSBuilt 1957 · S/N 23-965N993HRObxpress LLC · Frisco, NCBuilt 1978 · S/N 31-7812105N9942GQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 31-7712088N995AKLake Clark Air Inc · Port Alsworth, AKBuilt 1977 · S/N 31-7752089N9974FShipp G Carl Md · Little Rock, ARS/N 27-4835N998FBRegistered aircraftN-number assigned, not yet registeredS/N 27-440N998LMArmstrong Airlines Inc · Dover, DEBuilt 1980 · S/N 31T-8120006N9993RCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-8052029N9999WScudder Adam · Orlando, FLBuilt 1976 · S/N 27-7654086N999FLMatthews Aviation LLC · Hardinsburg, KYBuilt 1957 · S/N 23-1115N999GKTaylor Craig E · Nantucket, MABuilt 1981 · S/N 31-8152101N99EGGrant Gerald F Trustee · Maplewood, MNBuilt 1973 · S/N 31P-7400180N99FPShort Jon P · Cullman, ALFirst renewal noticeBuilt 1978 · S/N 27-7854119N99MDJinkins Richard D · Rewey, WIBuilt 1955 · S/N 23-325N99TBHadden Banjamin D · Incline Village, NVBuilt 1976 · S/N 31-7612074N99VATwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 31T-7720007N9APWellsville Flying Service Inc · Wellsville, NYS/N 27-7305129N9FWWright Air Service Inc · Fairbanks, AKBuilt 1974 · S/N 31-7405468N9QExecutive Express LLC · Elizabeth City, NCBuilt 1975 · S/N 31-7512014N9TXRegistration Pending · San Ysidro, CARegistration pending, canceledBuilt 1978 · S/N 31-7812060
Back to AD 2009-13-06 R1