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.

N5583ZWoods Robert L · Kenly, NCBuilt 1962 · S/N 22-9390N5584H51 Pacer LLC · Jacksonville, ORS/N 20-644N5584PPinnell Roger D · Shell Knob, MOBuilt 1959 · S/N 24-648N5584ZDerrico Andrew D · Leesburg, FLS/N 22-9393N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649N5585ZHeitz John W · Manvel, TXBuilt 1962 · S/N 22-9394N5586HCannata Michael A · Estancia, NMBuilt 1951 · S/N 20-647N5586ZKoenig Anthony Scott · Huntsville, TXBuilt 1962 · S/N 22-9395N5587ZWeesies Jack · Saint Petersburg, FLBuilt 1962 · S/N 22-9396N5588PNorth Town Comanche LLC · North Las Vegas, NVBuilt 1959 · S/N 24-654N5588YBrennan Thomas F · Titusville, PAS/N 27-2695N5588ZSpooner John A · Hickory, NCBuilt 1962 · S/N 22-9397N5589HAdams Trevor J · Burlington, WABuilt 1951 · S/N 20-651N5589PEggers Cindy S · Winnemucca, NVBuilt 1959 · S/N 24-655N5589ZDayton Stephen G · Littleton, NHBuilt 1962 · S/N 22-9399N558PCSammons Aero Services LLC · Edgewood, TXBuilt 1958 · S/N 24-333N5590HZonnefeld Mark J · Olathe, KSBuilt 1951 · S/N 20-653N5590PUdall Thomas H · Mckinney, TXBuilt 1958 · S/N 24-656N5590ZWhitaker Shawn P · Mount Pleasant, SCBuilt 1962 · S/N 22-9400N5592PWelch Roy T · Garfield, WABuilt 1959 · S/N 24-658N5593HLandreth Homer W · Peoria, AZBuilt 1951 · S/N 20-655N5593PDingus Donald E Jr · Brownfield, TXBuilt 1959 · S/N 24660N5593ZEastern Stearman Inc Trustee · Leesburg, VABuilt 1962 · S/N 22-9404N5595HHornby James C · Kaukauna, WIBuilt 1951 · S/N 20-659N5596ZLamb Steve E · Big Bear City, CABuilt 1962 · S/N 22-9407N5597HNicholson Robert Lyle · North Ogden, UTS/N 20-661N5598ZEkstrom David L · Bemidji, MNBuilt 1962 · S/N 22-9409N55993Karsenti Ziva · Galesburg, KSBuilt 1973 · S/N 36-7360025N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55MTKramp William J · Post Falls, IDBuilt 1966 · S/N 27-3575N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307N5600PBfi Inspections LLC · Nevada City, CAS/N 24681N5601PDevil Dusters Inc · Artesia, NMS/N 24-669N5603PLitteken David T · Aviston, ILBuilt 1959 · S/N 24-671N5603ZAngerman Ronald A · Gilbert, SCBuilt 1962 · S/N 22-9413N5605ZMossman Aaron P · West Plains, MOS/N 22-9408N5607ZCorcoran Francis A · Rochelle, ILBuilt 1962 · S/N 22-9418N5608ZSale Reported · Casper, WYSale reportedBuilt 1962 · S/N 22-9420N5609ZRowland Gary W · Edmond, OKBuilt 1962 · S/N 22-9421N560DBAnderson Aerial Spraying Svc Inc · Canby, MNBuilt 1964 · S/N 27-2722N5610ZMcvey James W · Mentor, OHBuilt 1962 · S/N 22-9422N5611PWeyland Aviation Inc · Lewes, DEBuilt 1959 · S/N 24-679N5612PClarity Aviation LLC · Boise, IDBuilt 1959 · S/N 24-680N5613ZAndersen Zachary J · Seward, AKBuilt 1962 · S/N 22-9424N5614PShetty Balakrishna · Wesley Chapel, FLBuilt 1959 · S/N 24-682N5615ZKuebler Terry T · Gahanna, OHBuilt 1962 · S/N 22-9427
Back to AD 85-02-05 R1