AD 85-02-05 R1

Registered aircraft · 8,921

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.

N3327BHilgendorf Douglas A · Welcome, MNBuilt 1954 · S/N 22-2142N3327ZMessinger Donald C · Wasilla, AKBuilt 1960 · S/N 22-7264N3328ATulis David · Frederick, MDBuilt 1953 · S/N 22-1603N3328BHarper Ken C · Kenai, AKBuilt 1954 · S/N 22-2143N3329PStradley Anna M Trustee · Bozeman, MTBuilt 1958 · S/N 23-1280N3330AJordan Don T · Midlothian, TXBuilt 1953 · S/N 22-1605N3331ABurgess Roy S · Lincoln, NEBuilt 1953 · S/N 22-1607N3332AMarinan Steve · Sanger, TXS/N 22-1606N3332ZWeisenburger Adam A · Seeley Lake, MTS/N 22-7269N3333BNorlin Lary G · Indianola, IAS/N 22-2148N3335ATwotards Aviation LLC · Moses Lake, WABuilt 1953 · S/N 22-1612N3335BHutsell James M · Miamisburg, OHBuilt 1954 · S/N 22-2150N3335ZGreen Francis E III · Frankfort, NYBuilt 1960 · S/N 22-7275N3336BNelson Morales · Hendersonville, NCBuilt 1954 · S/N 22-2151N3336ZCedar Mark P · Cherokee, IABuilt 1960 · S/N 22-7276N3337BJohnson Rader · Cedar City, UTBuilt 1954 · S/N 22-2152N3338BLvft Aviation Inc · Wilmington, DEBuilt 1954 · S/N 22-2153N3338ZKeil Lawrence L · Anchorage, AKBuilt 1960 · S/N 22-7278N3339BStraub Kerry D · Grants Pass, ORBuilt 1954 · S/N 22-2154N3339PGeorge James Cooper · Lenoir, NCBuilt 1958 · S/N 23-1291N333CBSecondary Minimums Task Force LLC · Kalispell, MTBuilt 1971 · S/N 24-5003N333CREob Aviation LLC · Grand Haven, MIBuilt 1968 · S/N 30-1671N333CXFlying Bs LLC · Canby, ORBuilt 1967 · S/N 24-4720N333FSAerodrome LLC · Louisville, KYBuilt 1969 · S/N 27-4456N333HJSchlender Mike · Clintonville, WIS/N 39-29N333HYFrantz Paul B · Abbeville, GABuilt 1963 · S/N 30-174N333JDDouglas Aero Inc · Fort Lauderdale, FLBuilt 1980 · S/N 27-8054016N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013N333SNHub City Aviation Academy LLC · Lubbock, TXBuilt 1966 · S/N 30-982N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099N333WYJrm Wings LLC · Farmington, UTS/N 30-1800N3340BHao Hangar Rats LLC · Fairfield, OHS/N 22-2155N3341AHolbrook Tmothy D · Traverse City, MIS/N 22-1507N3341BPort Townsend Aero Museum · Port Townsend, WABuilt 1954 · S/N 22-2156N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294N3342BAmy Jason R · Minneola, KSBuilt 1954 · S/N 22-2157N3342ZNies Juergen · Winchester, VABuilt 1960 · S/N 22-7282N3344BVan Vleet Clifford · Sierra Vista, AZBuilt 1954 · S/N 22-2159N3346BHospodar Robert P · Georgetown, PAS/N 22-2161N3346PDramstad Flying Service LLC · Helena, MTS/N 23-1299N3347ARegistered aircraftBuilt 1953 · S/N 22-1617N3349ZPorter Curtiss L · Woodscross, UTBuilt 1960 · S/N 22-7289N3350ZKintner Daniel S · Conyers, GAS/N 22-7290N3352ZLoppnow Martin L · Yermo, CAS/N 22-7292N3353PHeffron Jacob L · Little Falls, MNBuilt 1958 · S/N 23-1308N33542Schmidt David L · Wasilla, AKBuilt 1957 · S/N 22-5108N3354ZJohnson Charles D · Benson, AZBuilt 1960 · S/N 22-7294N3357ZHannon Harland N · Big Lake, AKBuilt 1960 · S/N 22-7297N3359ZKistler Stephen M Trustee · Monument, KSBuilt 1960 · S/N 22-7299N335BFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 30-1389
Back to AD 85-02-05 R1