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.

N9220PDavid Rever Aviation LLC · Dewey Beach, DEBuilt 1967 · S/N 24-4716N9221PStevenson Tom · Portland, ORBuilt 1967 · S/N 24-4718N9222DMatthews David C · Fairbanks, AKBuilt 1958 · S/N 22-6282N9222PAztec Remains LLC · Potosi, WIBuilt 1967 · S/N 24-4719N9224PAnde Leasing Co LLC · Edgewood, NMS/N 24-4721N9225PRegistered aircraftBuilt 1967 · S/N 24-4722N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286N9226FLewis University · Romeoville, ILBuilt 1990 · S/N 4495011N9227PSiebold Peter · Tehachapi, CABuilt 1967 · S/N 24-4717N9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288N9228PShillig Vance R · Colorado Springs, COS/N 24-4726N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289N9229PKoeman Scott B · Fort Moore, GAS/N 24-4727N922JMApplied Aerospace Concepts Pllc · Bloomington, MNBuilt 1972 · S/N 24-5017N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9231PSeaton Flying Services Inc · Salado, TXBuilt 1967 · S/N 24-4729N9233PBlandina Leon V · New Hudson, MIBuilt 1967 · S/N 24-4731N9235PJen Lyn Inc · Wilmington, DEFirst renewal noticeBuilt 1967 · S/N 24-4734N9236PTasso Aviation LLC · Orrville, ALS/N 24-4735N9237PCloud Climibers LLC · Lexington, KYBuilt 1967 · S/N 24-4736N9238PPylant Eric Jon · Arnold, CABuilt 1967 · S/N 24-4737N9241PGaskill Jeffrey V · Weston, MOS/N 24-4740N9242DWeishaar Wallace · Livingston, TXBuilt 1958 · S/N 22-6302N9242PDekervor Marc Phillippe II · La Mesa, CAS/N 24-4741N9243DPiper Aviation Museum Foundation · Lock Haven, PABuilt 1958 · S/N 22-6303N9243PKanne Michael J · Des Moines, IABuilt 1967 · S/N 24-4742N9244DShrode Rafe C · Jewett, TXS/N 22-6304N9246PSharp Paul C · Modesto, CABuilt 1967 · S/N 24-4745N9247DLaw C Scott · Oklahoma City, OKBuilt 1958 · S/N 22-6307N9247PEhrenberg David G · Corning, NYBuilt 1968 · S/N 24-4746N9248PPajaro Jaison · Burtonsville, MDBuilt 1966 · S/N 24-4627N924ANielsen Arvid L · Two Harbors, MNBuilt 1951 · S/N 22-228N924CCSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N 27-3490N9250PBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 24-4747N9251PSalori Aviation LLC · Centralia, MOBuilt 1967 · S/N 24-4749N9252POsipov Yuri A · Lomita, CABuilt 1967 · S/N 24-4750N9253PConway Brandon · Springtown, TXBuilt 1967 · S/N 24-4751N9254PMeyer Aviation LLC · South St Paul, MNBuilt 1968 · S/N 24-4752N9255PSalvia Michael · Farmington Hills, MIBuilt 1968 · S/N 24-4754N9256XBird Acquisition LLC DBA · Phoenix, AZBuilt 1995 · S/N 4496002N9258PCessna 79432 LLC · Missoula, MTBuilt 1968 · S/N 24-4757N9259PChiarini Joshua · Cranston, RIBuilt 1968 · S/N 24-4758N925DGNwi Drones LLC · Chesterton, INBuilt 1960 · S/N 24-1870N9262PReliant Aeroworks LLC · Sanger, TXBuilt 1968 · S/N 24-4761N9263PWhitacre John B III · Waynesburg, OHBuilt 1968 · S/N 24-4762N9264PBeil Richard P Trustee · Caroline, WIBuilt 1968 · S/N 24-4763N9267PNickravesh Niknam J · San Jose, CABuilt 1968 · S/N 24-4767N9268PAts Inc · Chicago, ILBuilt 1968 · S/N 24-4768N9269PRegistered aircraftBuilt 1968 · S/N 24-4769N926AWeishaar Wallace O · Livingston, TXBuilt 1951 · S/N 22-229
Back to AD 85-02-05 R1