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.

N1418CWaaam Volunteer Flying Association LLC · Hood River, ORS/N 22-1175N14202Hodge Uriel · St Thomas, VIS/N 27-4762N14207Belk William E · Labelle, FLBuilt 1971 · S/N 27-4767N1421AKoplitz Wesley D · Oshkosh, WIS/N 22-336N14224Townley William V · Weirsdale, FLBuilt 1972 · S/N 27-4783N14229Holt Bryan J · Flowery Branch, GABuilt 1972 · S/N 27-4794N14243Blitz Daniel R · Corsicana, TXBuilt 1972 · S/N 27-4795N14244Pacific Fleet Aviation LLC · Rochester, NYBuilt 1972 · S/N 27-4796N1424AStacey Steve L · Hutchinson, KSBuilt 1951 · S/N 22-338N1424NEbonaster Enterprises LLC · Slidell, LABuilt 1966 · S/N 24-4383N14252Caja Aviation LLC · Cheyenne, WYBuilt 1972 · S/N 27-4813N14268Kilgore Garrett M · Whitwell, TNS/N 27-4828N1426SBoundless LLC · Dakota Dunes, SDBuilt 1971 · S/N 27-4680N1427CGdm Properties LLC · Huron, OHBuilt 1953 · S/N 22-1179N1427SCasa Jets Inc · Pittsford, NYS/N 27-4831N14281Technical Education Services Inc T/A · Virginia Beach, VABuilt 1972 · S/N 27-4843N1428CHolder Ward S · Oxnard, CARegistration revokedBuilt 1953 · S/N 22-1180N1429CLarge Jonathan B · Mahnomen, MNBuilt 1953 · S/N 22-1183N142CATack Kenneth W · Taft, CABuilt 1959 · S/N 24-1161N142EN142e LLC · Page, AZBuilt 1967 · S/N 30-1479N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177N142VPMortland Thomas F · Duxbury, MABuilt 1959 · S/N 23-1593N1431AKoiter Jason A · Prescott Valley, AZBuilt 1951 · S/N 22-347N1432MLarson Sean P · Fairbanks, AKS/N 23-432N1434CSherman Jeff Co Ow · Elkhart, INRegistration revokedBuilt 1953 · S/N 22-1189N14350Pema Aviation LLC · Tavernier, FLBuilt 1972 · S/N 27-7304933N14368Semeniuk Steven T · Houston, TXBuilt 1972 · S/N 27-7304956N14379Bas Part Sales LLC · Greeley, COS/N 27-7304970N1437CChilders Daniel A · Hartwell, GAS/N 22-1192N14386Blue Star Aviation Services LLC · Shippensburg, PABuilt 1972 · S/N 27-7304980N1438PTri Rotor Spray & Chemical · Ulysses, KSS/N 23-496N14394Pavco Inc · Gig Harbor, WABuilt 1972 · S/N 27-7304991N143ACPotcake Aviation LLC · Missoula, MTBuilt 1972 · S/N 27-7304989N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18N14401Berggren Ryan · Newton, NJBuilt 1967 · S/N 27-3722N1440CChamberlain Howard D · Lisbon, OHBuilt 1953 · S/N 22-1194N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478N1441CTroyer Cody L · Macon, MSS/N 20985N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036N144JWWarren Joy A · White Lake, MIS/N 22-7286N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323N144TLNielson Mark Allen · Willmar, MNBuilt 1959 · S/N 24-1205N1452PSorenson Mark A · Senoia, GABuilt 1956 · S/N 23-515N1454PLansing Community College · Mason, MIBuilt 1956 · S/N 23-517N1455PMohamed Eman Z · Lubbock, TXBuilt 1956 · S/N 23-518N1456AMcbride Michael S · Allentown, PABuilt 1951 · S/N 22-359N1457ASanderson Michael E · Newberg, ORS/N 22-357N145ABAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3137N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145N1460PBas Part Sales LLC · Greeley, COS/N 23-523
Back to AD 85-02-05 R1