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.

N235AUNorcross Ashley S · Anchorage, AKS/N 22-9772N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587N235WERudloff Uwe K · Lake Village, INBuilt 1975 · S/N 25-7556108N2360QStar Ads Incorporated · Torrance, CABuilt 1979 · S/N 25-7956034N2360YEggemeyer Bradford J · Groom, TXBuilt 1981 · S/N 36-8160017N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027N2369XChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 4496291N236MTPiper Aircraft Inc · Vero Beach, FLS/N 4496659N2371ACael David P · Folsom, CABuilt 1952 · S/N 22-734N2371PZmirly Aviv · San Diego, CABuilt 1955 · S/N 22-2762N2375PKirsteatter Todd · Kewaunee, WIBuilt 1955 · S/N 22-2766N2376PBoyd Paul E · North Pole, AKBuilt 1955 · S/N 22-2767N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116N237MTPiper Aircraft Inc · Vero Beach, FLS/N 4496660N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774N2384PLarsen Steve J · Colton, ORS/N 22-2775N2385ADevries Myles · Cut Bank, MTBuilt 1952 · S/N 22-750N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037N2390AAgnew Michael D · Pardeeville, WIS/N 22-756N2390PLubben Thomas H · Madison, WIBuilt 1955 · S/N 22-2781N2391POberholtzer Robert H · Streator, ILBuilt 1955 · S/N 22-2782N2392PWagar Dennis M · Marion, MTBuilt 1955 · S/N 22-2783N2394AMykyte Dustin D · Houston, TXFirst renewal noticeS/N 22-758N2394PLamontagne Kyle H · Portland, TNBuilt 1955 · S/N 22-2785N2399PHoffa John C · South Bend, INS/N 22-2790N2399UChilhowee Soaring Association Inc · Benton, TNBuilt 1972 · S/N 25-5429N239ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496038N23ASRusso James F · Liberty, SCS/N 27-3094N23AUAverett University · Danville, VABuilt 2024 · S/N 4496570N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003N23BMAxiom Development And Consulting LLC · Atlanta, GABuilt 1959 · S/N 24-1118N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52N23GNMidwest General And Mechanical Contractors Inc · Highland, WIS/N 23-1415N23LGGist Thomas Hottel III · Little Rock, ARBuilt 1959 · S/N 24-832N23MGNewhall William G · Longmont, COBuilt 1971 · S/N 39-28N23RBCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4108N23RDRegistered aircraftS/N 30-469N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565N24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496290N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049N2407VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002019N2409AVeldhuizen Richard B · Jesup, GABuilt 1952 · S/N 22-778N2409VPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 36-8002020N240AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496650N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108
Back to AD 85-02-05 R1