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.

N9398PS & T Aviation LLC · Meriden, IABuilt 1969 · S/N 24-4902N939CAMcs Aviation LLC · Larned, KSBuilt 1965 · S/N 24-4222N939LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496484N93BDColeman William R · Jasper, ARBuilt 1967 · S/N 30-1433N93MVWell Bilt Industries USA LLC · Ocala, FLBuilt 1979 · S/N 27-8054029N93PAIsbell Brian K · Rosenberg, TXBuilt 1982 · S/N 44-8207015N93UGBellas Business LLC · Kalispell, MTS/N 23-350N9400PKoretsky Aviation LLC · Fairless Hills, PABuilt 1969 · S/N 24-4904N9401DBenesh Stephen P · Oshkosh, WIBuilt 1958 · S/N 22-6374N9402PSteinberg Franklyn C III · Flemington, NJBuilt 1969 · S/N 24-4907N9403DKlingenberg Tim C · Udall, KSBuilt 1958 · S/N 22-6376N9406DMartin James D Sr · Coeur D Alene, IDS/N 22-6379N9407DMatthew P R Mcdaniel · Oak Creek, WIBuilt 1958 · S/N 22-6381N9407PHoefle Aviation Inc · Wilmington, DEBuilt 1969 · S/N 24-4912N9409PDormond Brent C · Glendale, CABuilt 1969 · S/N 24-4914N940LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496485N9411DForsyth Bryan Oliver · Truckee, CABuilt 1958 · S/N 22-6385N9411PHomsi Joseph · Dover, NJBuilt 1970 · S/N 24-4916N9412DSchlamer Mark A · Campbellsport, WIBuilt 1958 · S/N 22-6386N9412PJ L Darr And Son Inc · High Point, NCBuilt 1969 · S/N 24-4917N9413DOl Blue LLC · Salt Lake City, UTBuilt 1958 · S/N 22-6387N9414PRegistered aircraftBuilt 1969 · S/N 24-4919N9415DRogers Samuel · Le Roy, KSBuilt 1958 · S/N 22-6389N9419DKintz Dale K · Astoria, ORBuilt 1958 · S/N 22-6393N9419PGreene Joseph B · Shafer, MNBuilt 1969 · S/N 24-4925N941MPHill John D · Reno, NVBuilt 1956 · S/N 22-4433N9424DBranch Clayton L · Winfield, KSBuilt 1958 · S/N 22-6398N9427PPaul Burrell Aircraft LLC · Spring, TXBuilt 1969 · S/N 24-4935N9430PBonn Fred H · Jamestown, KYBuilt 1970 · S/N 24-4938N9433DPacer Flight LLC · Huron, OHBuilt 1958 · S/N 22-6407N9434PSheehan James A · Newberg, ORBuilt 1970 · S/N 24-4942N9435PWahl John B · Pendleton, ORBuilt 1970 · S/N 24-4943N9436PWarren Michael W · Wiscasset, MES/N 24-4944N9438DWeidner Kevin G · Bunker Hill, ILBuilt 1958 · S/N 22-6412N9438PZimmerman Kyle R · Gilbert, AZBuilt 1970 · S/N 24-4946N9443PNyhus Daniel Alan · Payson, AZBuilt 1970 · S/N 24-4951N944ATerhune Keith B · Crosby, TXBuilt 1951 · S/N 22-258N9450PSmh Aviation LLC · Dallas, TXBuilt 1970 · S/N 24-4957N9452PRegistered aircraftBuilt 1971 · S/N 24-4959N9453PWhitehead Dennis C · Iron Mountain, MIBuilt 1970 · S/N 24-4961N9454PJohnson Roger D · Fort Meade, FLS/N 24-4962N9457PN84dt LLC · Missoula, MTBuilt 1971 · S/N 24-4965N9458PAmerican Standard Aviation LLC · Burleson, TXBuilt 1971 · S/N 24-4966N9459PRegistered aircraftBuilt 1971 · S/N 24-4967N9462PInternational Air Services Inc Trustee · Carson City, NVS/N 24-4970N9465PFtb Aviation LLC · Arden, NCS/N 24-4974N9467PRiver Aviation LLC · Wilmington, DEBuilt 1971 · S/N 24-4977N9468PSmall Alan J · Bristol, RIBuilt 1971 · S/N 24-4978N946AKotranza Robert R · Houghton Lake, MIBuilt 1951 · S/N 22-252N9471PFly Yawa Aviation LLC · Statesboro, GAS/N 24-4982
Back to AD 85-02-05 R1