OpenAirDocs.org
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.

N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004N2583QDykstra Tony R · Pipestone, MNS/N 25-8056049N258RMNighthawk N8231g LLC · Pompano Beach, FLS/N 44-8107029N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007N2596ARoach Wesley R · Marietta, GABuilt 1952 · S/N 22-875N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080N25FTPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754038N25JFBuckingham James M · Palmer, AKBuilt 1968 · S/N 27-3903N25MHumble Ventures Inc · Tempe, AZBuilt 1965 · S/N 24-4221N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105N25PRInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1511N25TJFerraro Thomas P · Mckinney, TXBuilt 1959 · S/N 22-6676N2604ZBurgan Grover W · Jacksonville, FLBuilt 1981 · S/N 27-8154012N2607PFattrusso Louis Anthony · South Chesterfield, VAS/N 22-2942N2608ZKaufield John E · Garden Prairie, ILBuilt 1981 · S/N 27-8154015N260BCFlying J LLC · Bulverde, TXBuilt 1967 · S/N 24-4606N260CDMarlow Bruce D - Trustee · Nevada City, CABuilt 1966 · S/N 24-4389N260DTInternational Air Services Inc Trustee · Carson City, NVS/N 24-4995N260FLFox Leasing Group LLC · Hollywood, FLBuilt 2023 · S/N 4496563N260GCFeline Health Inc · Hampstead, NCBuilt 1969 · S/N 24-4834N260JFKropp Christian Trustee · Azle, TXBuilt 1965 · S/N 24-4196N260NCYounhorsh Sales LLC · Wilmington, DEBuilt 1969 · S/N 24-4855N260PCRegistered aircraftBuilt 1965 · S/N 24-4125N260SCN260sc Partnership Group LLC · Ogden, UTBuilt 1964 · S/N 24-3678N2610AGreen-Way Essentials LLC · Arkansas City, KSBuilt 1952 · S/N 22-891N2613PBraun Daniel R · Damascus, ORS/N 22-2948N2614ADixon Eric A · Salado, TXBuilt 1952 · S/N 22-896N2616ARegistration Pending · Aleknagik, AKRegistration pendingBuilt 1952 · S/N 22-895N2618ALevin Henry · Medford, ORS/N 22-902N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091N2624PRobinson Eric C · Palmer, AKS/N 22-2960N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963N2628PCraig Richard L · Sonoma, CAS/N 22-2965N2631AHarper Clayton E · Seabrook, TXBuilt 1952 · S/N 22-903N2631PFriebel Mark A · Shelby, OHBuilt 1955 · S/N 22-2968N2633AReich Dan E · Walla Walla, WABuilt 1952 · S/N 22-905N2635PSchuller Henry Michael · Arlington, WABuilt 1955 · S/N 22-2973N2637PMurray James A · Wasilla, AKBuilt 1955 · S/N 22-2975N263ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496087N2640PCrumley Emily M · Bristol, TNBuilt 1955 · S/N 22-2978N2641AWhitcomb Glenn R · West Richland, WABuilt 1952 · S/N 22-910N2647PTrinkle Aviation LLC · Kingsburg, CABuilt 1955 · S/N 22-2985N2649PHoffmann Greg L · Centennial, COBuilt 1955 · S/N 22-2987N264ATAirline Transport Prof Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496088N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633N2650AKulick Douglas F · Reno, NVBuilt 1952 · S/N 22-920N2650PGodlewski John A · Ormond Beach, FLS/N 22-2988
Back to AD 85-02-05 R1