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.

N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161N1611PBoyer Scott C · Custar, OHBuilt 1954 · S/N 22-2425N1616POwen David C · Fort Myers, FLBuilt 1954 · S/N 22-2430N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106N161PRegistered aircraftBuilt 1958 · S/N 24-533N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441N162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496429N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72N1630PSmith Richard D · Williamstown, OHBuilt 1954 · S/N 22-2444N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446N1642PBangerter Timothy W · Leoti, KSBuilt 1954 · S/N 22-2458N1643PPacer Air LLC · Wilmington, OHBuilt 1954 · S/N 22-2459N1645AHayden Aviation LLC · Rhome, TXBuilt 1952 · S/N 20-843N1646PGerigs Trucking And Leasing Inc · Hoagland, INBuilt 1954 · S/N 22-2462N1648ARenner Daniel T · Crooks, SDS/N 22-411N1649AHudgin James P · Lewisburg, TNBuilt 1952 · S/N 22-412N1649BBurke Cary C · Lake Stevens, WAS/N 22-2037N1649PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 22-2465N1655AConnell Romeao J · Gresham, ORS/N 22-419N1659ARowell Tony A · Westerville, OHBuilt 1952 · S/N 22-415N1663POakes Stephen · Joshua Tree, CAS/N 22-3089N166SPSwitzer James DBA · Costa Mesa, CABuilt 1964 · S/N 26-79N1673ASheeley Patrick D · High Falls, NYBuilt 1952 · S/N 22-436N1679ARostron Christopher M · Kokomo, INS/N 22-441N1680APaprocki Jason C · Fairplay, COS/N 20-842N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1682AMackie Scott B · Woodstock, GABuilt 1952 · S/N 20848N1684PTharpe George W · Street, MDBuilt 1955 · S/N 22-2470N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1687PSofia De Venecia LLC · Southampton, NYBuilt 1954 · S/N 22-2473N1690PPritchett Michael L · Benton, ARS/N 22-2476N1691AChase 13 LLC · Wilmington, DEBuilt 1952 · S/N 22-448N1691PTomporowski Robert C · Mahwah, NJS/N 22-2477N1692AAdams Steve W · Ranger, TXBuilt 1952 · S/N 22-444N1692PHoffmeyer Ronald P · Rapid City, SDBuilt 1954 · S/N 22-2478N1693AHarp Kenneth F · Lake Geneva, FLBuilt 1952 · S/N 22-449N1697PConnolly Joseph III · Redding, CABuilt 1954 · S/N 22-2483N1698PJobe Kevin D · Sutton, AKBuilt 1954 · S/N 22-2484N169ABSouthern Cub And Aircraft Restoration LLC · Pensacola, FLBuilt 1968 · S/N 25-4517N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693N16DPNdmi Inc · Greeneville, TNS/N 24-3024N16MBLancaster Wesley A · Saint Augustine, FLBuilt 1961 · S/N 22-8387N16NJBurke Bryan E · Broomfield, COBuilt 1969 · S/N 30-1845N16REFly Pnw LLC · Maple Valley, WAS/N 22-6518N16TWBaughman Kevin · Avinger, TXBuilt 1964 · S/N 30-527N1701PRegistration Pending · Walla Walla, WARegistration pending, pending cancellationS/N 22-2488
Back to AD 85-02-05 R1