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.

N6720BGonsioroski Jerry D · Baker, MTBuilt 1956 · S/N 22-4053N6720PWhipple Daniel · Oklahoma City, OKBuilt 1960 · S/N 24-1847N6723PNapoliello Kent · Boca Raton, FLBuilt 1960 · S/N 24-1850N6724BSuchovsky Joshua A · Indianapolis, INBuilt 1956 · S/N 22-4057N6724ZGray Ronald W · Hooker, OKBuilt 1963 · S/N 25-2339N6725BCallen Jeremy T · Filer, IDBuilt 1956 · S/N 22-4058N6726BNickel Henry William · San Bernardino, CABuilt 1956 · S/N 22-4059N6727ZMyers Randall · Parshall, NDBuilt 1963 · S/N 25-2343N6729PDarr Henry H · Drummond, MTBuilt 1960 · S/N 24-1856N672MCNorthwestern Michigan College · Traverse City, MIBuilt 2026 · S/N 4496640N6730PShea Kelly P · Providence, RIBuilt 1960 · S/N 24-1857N6730YUrubek Raymond L · Refugio, TXS/N 27-4062N6731PMeadlin Melvin Mathew II · Thornton, COBuilt 1960 · S/N 24-1858N6734PMaedl Marcus · Vista, CABuilt 1960 · S/N 24-1861N6735BBallard Donald · Conneaut, OHS/N 22-4068N6737PEhni Scott M · Trinity, TXBuilt 1960 · S/N 24-1865N6739BDeal Stuart F · Santa Rosa, CABuilt 1956 · S/N 22-4072N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073N673SASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-2240N6741BPoehler Fred G · Newberg, ORBuilt 1956 · S/N 22-4074N6743PFrancis Sean · Pittstown, NJBuilt 1960 · S/N 24-1871N6744PGanton Robert B · San Diego, CAS/N 24-1872N6745ZSouthern California Soaring Academy · Valencia, CABuilt 1963 · S/N 25-2360N6746PCoppola Marc · Waretown, NJBuilt 1960 · S/N 24-1874N6749BFinke Andy R · North Liberty, INS/N 22-4083N6749ZKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 25-2368N6751BCook Harry F · Sequim, WABuilt 1956 · S/N 22-4085N6751PGette Jason D · Kindred, NDS/N 24-1880N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079N6753BThorpe Brandon · Bremerton, WABuilt 1956 · S/N 22-4087N6753PScanlon Shawn M · Evans, GABuilt 1960 · S/N 24-1882N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083N6755BTwotards Aviation LLC · Moses Lake, WABuilt 1956 · S/N 22-4089N6756ZKoenig Donald J · Las Animas, COBuilt 1963 · S/N 25-2376N6757BStuart Lee L · Smithville, ARBuilt 1956 · S/N 22-4091N6758PRoss David T · El Dorado Hills, CABuilt 1960 · S/N 24-1887N6759BDean Richard L · Ridgeland, SCBuilt 1956 · S/N 22-4094N6760AFreestone William W · Saint Augustine, FLS/N 27-7954086N6762PKimsey Thomas W · Warner Robins, GAS/N 241892N6763PHeublein Eric C · Molalla, ORBuilt 1960 · S/N 24-1893N6765PJamison Ronnie L · Phoenix, AZBuilt 1960 · S/N 24-1895N6766PStephens Christopher R · Upper Marlboro, MDBuilt 1960 · S/N 24-1896N6768PKeenan John E · Saratoga, CABuilt 1960 · S/N 24-1899N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100N6771PBach Keith · Hilton Head Island, SCBuilt 1960 · S/N 24-1902N6774PWw LLC · Sioux Falls, SDBuilt 1960 · S/N 24-1905N6775PBowen James V · Huntingtown, MDBuilt 1960 · S/N 24-1906N6776APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954088N6777YPlaquemines Parish Government · Belle Chasse, LABuilt 1968 · S/N 27-4109N6778PBrown Jody T · Talco, TXBuilt 1960 · S/N 24-1909
Back to AD 85-02-05 R1