OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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.

N7741DJacko Josh E · Anchorage, AKS/N 22-5419N7741ZNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-3920N7742DSims Robert E · Richardson, TXBuilt 1957 · S/N 22-5420N7742KHanson Rustin W · Spokane, WABuilt 1950 · S/N 20-565N7743DHann James M · Ballwin, MOBuilt 1957 · S/N 22-5422N7743PWelch Brandon D · Liberty Hill, TXBuilt 1961 · S/N 24-2958N7743YSchroeder David C · Norfolk, NEBuilt 1965 · S/N 30-833N7744KOhlau Mark A · Wellington, NVBuilt 1950 · S/N 20-567N7744YCossette Aircraft LLC · Laporte, MNBuilt 1965 · S/N 30-835N7745DSale Reported · Joseph, ORSale reportedBuilt 1957 · S/N 22-5425N7745KDe Vecchi Guiancarlo Sergio · Montague, NJBuilt 1950 · S/N 20-568N7745PFleming James D · Alamosa, COBuilt 1961 · S/N 24-2960N7746KBuergel Sandra J · East Aurora, NYBuilt 1950 · S/N 20-569N7746PFlip Flops & Flight Plans LLC · Saint Petersburg, FLBuilt 1962 · S/N 24-2961N7746YSnow Robert I · New Caney, TXBuilt 1965 · S/N 30-837N7747YBohannon Philip Wayne · Houston, TXBuilt 1965 · S/N 30-838N7748DJagust William M · Troy, MOBuilt 1957 · S/N 22-5428N7748PCardiovascular Service Associates · Downers Grove, ILBuilt 1961 · S/N 24-2963N7749DOakley Lance E · Conway, ARS/N 22-5429N7750DCarruthers Matthew L · Charlotte Hall, MDBuilt 1957 · S/N 22-5430N7750PLeonardi Aldo · Woodland, CAS/N 24-2775N7750YWelden Charles R · Hoover, ALFirst renewal noticeBuilt 1965 · S/N 30-853N7751PGulf South Aero LLC · Raymond, MSBuilt 1961 · S/N 24-2965N7753KEckman Jane M · Port Orange, FLBuilt 1950 · S/N 20-570N7753PDarr Jacob L · Trinity, NCBuilt 1962 · S/N 24-2967N7753ZSt Louis Soaring Association Inc · Saint Louis, MOS/N 25-3936N7754KKoch Paul D · Morgan Hill, CABuilt 1951 · S/N 20582N7754PMagner Air LLC · Leesburg, VABuilt 1961 · S/N 242969N7755DWellborn Ralph Lee · Kenai, AKBuilt 1957 · S/N 22-5436N7755PBubak Land And Cattle LLC · Imperial, NEBuilt 1961 · S/N 24-2971N7756DFalley Leighan T · Talkeetna, AKBuilt 1957 · S/N 22-5438N7756P56pop LLC · Fremont, OHBuilt 1962 · S/N 24-2972N7756ZBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1966 · S/N 25-3942N7757ZMinden Soaring Club Inc · Minden, NVS/N 25-3943N7758PSkalsky Todd A · Hartley, TXBuilt 1961 · S/N 24-2974N7758YMead Aviation LLC · Missoula, MTBuilt 1965 · S/N 30-790N7759DVezina Robert J · Rockford, MIBuilt 1957 · S/N 22-5442N775TSSmith Paul A · Trufant, MIBuilt 1976 · S/N 27-7654069N7760KGleason Thomas K · Sedalia, MOBuilt 1951 · S/N 20-594N7761YBytes Aviation LLC · Poolesville, MDBuilt 1965 · S/N 30-848N7764PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2981N7764ZUnited Aerial Advertising Of Delaware Inc · Sparta, NJBuilt 1966 · S/N 25-3957N7765PRegistered aircraftBuilt 1961 · S/N 24-2982N7765YAce Vne LLC · Stevensville, MIBuilt 1965 · S/N 30-852N7767PStock Keith A · Warrensburg, MOS/N 24-2983N7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAS/N 24-2984N7769ZCentral Air Parts Inc · Staunton, ILS/N 25-3963N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078N7770PGlau Jon E · Englewood, COBuilt 1961 · S/N 24-2986
Back to AD 85-02-05 R1