OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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.

N2652PInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 22-2992N2653PKoerner Stephen F · Kankakee, ILBuilt 1955 · S/N 22-2993N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994N265ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496098N2660PAnderson William B · Rogers, ARBuilt 1955 · S/N 22-3000N2663PHoffrage Michael B · Fresno, CAS/N 22-3003N266ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496104N266LCCambridge Aviation LLC · Hillsborough, NJBuilt 1966 · S/N 30-1157N266WLowell James · Tucson, AZS/N 24-1923N2673AWilde Air Service LLC · Volga, SDBuilt 1953 · S/N 22-933N2675ATroyer Robert Earl · Toledo, WAS/N 20-952N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482N2686AJohnson James L · Greenville, TXBuilt 1953 · S/N 22-1099N268DASpartan Education LLC · Tulsa, OKBuilt 2002 · S/N 4496135N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798N26BWBestul Greg · Lester Prairie, MNBuilt 1967 · S/N 30-1559N26CXCiholas Philippe A · Sedgwick, KSBuilt 1970 · S/N 244949N26FTDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7754059N26RJRoedel Road Co · Kewadin, MIBuilt 1969 · S/N 30-1886N2704PBriggs Ralph H · Des Moines, IABuilt 1955 · S/N 22-3010N2706PFraser William G · Berkley, MABuilt 1955 · S/N 22-3012N2709PRuble Marsha L · Aurora, ORBuilt 1955 · S/N 22-3015N270GGSkylens LLC · Hammond, LABuilt 1975 · S/N 27-7554085N270RBaxter Thomas L · Stockbridge, GABuilt 1958 · S/N 23-1456N270SUPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496645N270WMsc Services Inc · Hugo, OKS/N 27-2129N2714PGeller Glen C · Beaverton, ORBuilt 1955 · S/N 22-3020N2715PNefstead Charles R · Willmar, MNBuilt 1955 · S/N 22-3021N2716PNeno Richard J · Ithaca, NYBuilt 1957 · S/N 22-5280N2720PLeguia Augusto A · Kathleen, GAS/N 22-3026N2726PDehaan Nathan M · Bethel, AKBuilt 1955 · S/N 22-3032N2728PBrown James A · Fairbanks, AKBuilt 1955 · S/N 22-3034N272GBaudouin Dameries · Pagosa Springs, COS/N 27-4189N272GTNfh Aviation LLC · Pikeville, KYS/N 44-7995054N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020N2746PParish Brandon · Mendon, UTBuilt 1955 · S/N 22-3053N2747PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-3054N2748PHess Gary A · Petoskey, MIBuilt 1955 · S/N 22-3055N274ERFlying Vikings Inc · Hayward, CAFirst renewal noticeBuilt 1978 · S/N 44-7995083N2750PHill Kevin M II · Dudley, MAS/N 22-3057N2751PSmith Kevin L · Peachtree City, GABuilt 1955 · S/N 22-3058N2752PAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1955 · S/N 22-3059N2759PWilkinson Kevin · Alliance, NES/N 22-3067N275FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496564N2760PDickerson Gary M · Homer, AKBuilt 1955 · S/N 22-3070N2761PCarlin Thomas J · N Richland Hills, TXBuilt 1955 · S/N 22-3071
Back to AD 85-02-05 R1