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.

N7685ZHigh Flights Soaring Club Inc · Peyton, COBuilt 1966 · S/N 25-3838N7686YMontana Leasing Group LLC · Park City, UTBuilt 1965 · S/N 30-766N7689YGitlow Stuart · Woonsocket, RIBuilt 1965 · S/N 30-769N7692PKelly Joseph · Austin, TXFirst renewal noticeBuilt 1961 · S/N 24-2902N7692YAloof Aviation LLC · Denver, COBuilt 1965 · S/N 30-774N7693PCrane James M · Clayton, NCBuilt 1961 · S/N 24-2903N7693YSkywalker Flight School LLC · Adrian, MIBuilt 1965 · S/N 30-775N7694KKingsley Jacob R · Oscoda, MIS/N 20-517N7694PN7694p Enterprises Inc · Dover, DEBuilt 1961 · S/N 24-2904N7695KChase 13 LLC · Wilmington, DES/N 20-515N7695YGriffith David B · Gilmer, TXBuilt 1965 · S/N 30-777N7696PJones Clayton S · Kalispell, MTBuilt 1961 · S/N 24-2907N7697PMascheck Anthony Q · Harker Heights, TXBuilt 1961 · S/N 24-2908N7697YRegistration Pending · Rosamond, CARegistration pending, canceledBuilt 1965 · S/N 30-780N7697ZTri-State Aerial LLC · Canton, SDBuilt 1966 · S/N 25-3856N7698PJohn Tom · Las Vegas, NVBuilt 1961 · S/N 24-2909N769MCRhs Consulting Ltd · Reno, NVBuilt 1973 · S/N 31P-7300131N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100N76FCBlackhawk Holding Corp · Wilmington, DEBuilt 1976 · S/N 27-7654082N76HKDodson International Parks Inc · Rantoul, KSBuilt 1958 · S/N 23-1423N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909N76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LABuilt 1972 · S/N 27-7304976N7700PBarber Chris · Toney, ALBuilt 1961 · S/N 24-2911N7701AEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496089N7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeS/N 22-5372N7702BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496090N7702DAnderson Leonard M · Lakeside, MTS/N 22-5374N7703CEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496091N7703DBureau Todd M · Hope, AKS/N 22-5375N7703YNixon Christopher M · Washington, INBuilt 1965 · S/N 30-789N7703ZBarrett Jane T · Tehachapi, CABuilt 1966 · S/N 25-3863N7704DSkyborne Airlines Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496092N7704PDolin Irving M · Gardner, KSBuilt 1961 · S/N 24-2916N7704ZAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3864N7705DPumphrey Ronald W · Houston, MSFirst renewal noticeBuilt 1957 · S/N 22-5377N7706YHighway Whisperer LLC · Wilmington, DES/N 30-794N7707GAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496096N7707PSweitzer Cameron D · Warrensburg, MOBuilt 1961 · S/N 24-2919N7707YLoveless John R Trustee · Bynum, TXBuilt 1965 · S/N 30-712N7708DR & R Hays Corp · Cody, WYBuilt 1957 · S/N 22-5380N7709DAk8 Assets LLC · Talkeetna, AKBuilt 1957 · S/N 22-5381N7709JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496100N7709YBauer Aviation LLC · Reese, MIBuilt 1965 · S/N 30-797N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296N7710KAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496101N7711Thomas Conrad H K · Lake City, FLS/N 24-3397N7711KVisser Paul C · Junction City, KSBuilt 1950 · S/N 20-532N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936N7711PWhitewater Aviation Inc · Harrison, OHBuilt 1961 · S/N 24-2924N7712PLenbom Mark A · Cameron, WIBuilt 1961 · S/N 24-2925
Back to AD 85-02-05 R1