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.

N888LCDay Michael J · Fort Wayne, INBuilt 1964 · S/N 30-272N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561N8890PElliott Charles · New Smyrna Beach, FLBuilt 1965 · S/N 24-4242N8891CSchroeder Thomas M · Georgetown, TXBuilt 1953 · S/N 22-1478N8891PTobias Ethan · West Haven, UTBuilt 1965 · S/N 24-4344N8891YGreat Plains Aero Inc · Iowa City, IABuilt 1970 · S/N 39-49N8892PN8892p LLC · Glendale, AZBuilt 1965 · S/N 24-4345N8894CBrent Thomas P · Walnut, MSBuilt 1953 · S/N 22-1475N8894PGarms Walter I III Trustee · Berkeley, CABuilt 1965 · S/N 24-4347N8895YRegistered aircraftS/N 39-52N8897PFey Ray D · Middleton, WIBuilt 1965 · S/N 24-4351N8897YAvion LLC · Lewes, DEBuilt 1970 · S/N 39-54N8898YWickenheiser Kenneth W · Sun City, AZBuilt 1970 · S/N 39-33N8899PLavoie Paul · Macon, GAS/N 24-4353N889NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496602N88APLangdon Brian B · Newcastle, WABuilt 1964 · S/N 30-456N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618N88FVandivort Aaron · Jacksonville, FLBuilt 1959 · S/N 24-1245N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112N88SHSmith Jeary K · Greenfield, INBuilt 1973 · S/N 27-7304930N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609N88WBJason Aviation LLC · Wilmington, DEBuilt 1964 · S/N 26-24N88WWQwest Aviation LLC · Edwardsburg, MIBuilt 1971 · S/N 39-125N8900DRay Robert L · Palmer, AKBuilt 1958 · S/N 22-6055N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355N8901DLeberman Odin F · Santa Maria, CABuilt 1958 · S/N 22-6056N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356N8902DTurkington Ryan · Homer, AKBuilt 1958 · S/N 22-6057N8902LIllini Glider Club · Danville, ILBuilt 1971 · S/N 25-5363N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357N8903DBesner Eugene F · Hemlock, MIS/N 22-6058N8903LPlane Fun Inc Tr Trustee · Snellville, GABuilt 1971 · S/N 25-5364N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358N8903YBall Half Out LLC · Mesa, AZBuilt 1970 · S/N 39-58N8904CClausen Robert G · Argyle, MNBuilt 1953 · S/N 22-1498N8904DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6059N8905CHowell Aviation LLC · Orlando, FLS/N 22-1499N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361N8906YRegistered aircraftBuilt 1970 · S/N 39-61N8907CGrizzly Skins Of Alaska Inc · Wasilla, AKBuilt 1953 · S/N 22-1502N8909DWellborn Michael A · Kenai, AKBuilt 1958 · S/N 22-6064N890NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496603N8910CBurns Edward D · Zillah, WABuilt 1953 · S/N 22-1506N8910DArmes John W · Elkhorn, WIS/N 22-6066N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365
Back to AD 85-02-05 R1