OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,481

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:84-10-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:84-10-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.

N759JMAas LLC · Ovid, MIBuilt 1977 · S/N 18266031N759JNMike Rinker Aircraft LLC · Union City, TNBuilt 1977 · S/N 18266032N759JRSeks Ventures Inc · Middletown, DEBuilt 1977 · S/N 18266035N759JXOptic Air LLC · Maurice, IABuilt 1977 · S/N 18266041N759KAAtmore Places LLC · Fernandina Beach, FLBuilt 1977 · S/N 18266044N759KBBoschma Henry F · Terrebonne, ORBuilt 1977 · S/N 18266045N759KCMccrea Daniel B · Waldport, ORS/N 18266046N759KDRegistered aircraftS/N 18266047N759KGWhite Thomas G II · Knoxville, PAS/N 18266050N759KJJohnson Thomas N · Greensboro, GAS/N 18266052N759KKWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1977 · S/N 18266053N759KMDahlen Donald · Isle, MNBuilt 1977 · S/N 18266055N759KPSc-Dsc LLC · Rocklin, CABuilt 1977 · S/N 18266057N759KQKudrna Kenneth D · Poplar Grove, ILBuilt 1977 · S/N 18266058N759KSAlessio Pretto G · Pawling, NYBuilt 1977 · S/N 18266060N759KTFrancis Larry Lee Dds Pc · Evanston, WYBuilt 1977 · S/N 18266061N759KVGorman Peter J · Valley Center, CABuilt 1977 · S/N 18266063N759KWRodgers Robert W · Louisville, KYS/N 18266064N759LCPegasus Aviation LLC · Moscow, IDS/N 18266070N759LDKnutson Wayne R · Thompson, NDS/N 18266071N759LEFridell Terrell · Charlotte, NCBuilt 1977 · S/N 18266072N759LFMurphy Carl Lee · Gastonia, NCBuilt 1977 · S/N 18266073N759LGTilton Glenn E · Cheyenne, WYBuilt 1977 · S/N 18266074N759LHKent William C Jr · Memphis, TNBuilt 1977 · S/N 18266075N759LKCs III Aviation LLC · New Orleans, LABuilt 1977 · S/N 18266077N759LPAzar Suzanne S · El Paso, TXBuilt 1977 · S/N 18266081N759LUMike-Upd LLC · Roseburg, ORBuilt 1977 · S/N 18266086N759LVJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266087N759LWOlson Dave · Richardton, NDBuilt 1977 · S/N 18266088N759LXLexiair LLC · Little Mountain, SCBuilt 1977 · S/N 18266089N759MAValley Fliers Inc · Auburn, WABuilt 1977 · S/N 18266092N759MBMiller Curtis Vern · Sugar Land, TXBuilt 1977 · S/N 18266093N759MKFarnsworth Harold · Mesa, AZBuilt 1977 · S/N 18266101N759MQPretre Alan G · Mitchell, SDBuilt 1977 · S/N 18266106N759MSMechanical Construction Services Inc · Newark, ARBuilt 1977 · S/N 18266108N759MUCool Creek Aviation LLC · New Orleans, LAS/N 18266110N759MVHirneisen Natalie A · Flourtown, PABuilt 1977 · S/N 18266111N759MWDirect North Inc · Solon, OHBuilt 1977 · S/N 18266112N759MXSchulz Roger B Trustee · Burlington, IABuilt 1977 · S/N 18266113N759MYN759 My LLC · Reading, MABuilt 1977 · S/N 18266114N759MZRochholz Edward · Medford, ORFirst renewal noticeBuilt 1977 · S/N 18266115N759NASteffora Philip T · Hollister, CABuilt 1977 · S/N 18266116N759NBClerget Joseph B · Bonney Lake, WABuilt 1977 · S/N 18266117N759NCRegistered aircraftBuilt 1977 · S/N 18266118N759NDNelson Donald O · Eureka, CABuilt 1977 · S/N 18266119N759NFN759nf LLC · Wilmington, DEBuilt 1977 · S/N 18266121N759NGWackman Ranch · Elk Grove, CABuilt 1977 · S/N 18266122N759NJBlair Aircraft No 1 LLC · Salt Lake City, UTBuilt 1977 · S/N 18266124N759NLGolden Thaddeus · Myrtle Beach, SCBuilt 1977 · S/N 18266126N759NRNugent Patrick L · Keller, TXBuilt 1977 · S/N 18266131
Back to AD 84-10-01 R1