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.

N17CRDawn Aviation LLC · Pierce City, MOBuilt 1965 · S/N 24-4093N17FWhiteside Andrew A · Essexville, MIBuilt 1954 · S/N 23-119N17MBAerocorp LLC · San Antonio, TXBuilt 1966 · S/N 30-1215N17PCCarolina Seaplanes LLC · Tega Cay, SCBuilt 1958 · S/N 22-5931N17PSNorris C · Land O Lakes, FLBuilt 1976 · S/N 31P-7630008N17TARetired Aviators Flying Club LLC · Oklahoma City, OKBuilt 1961 · S/N 24-2652N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118N1801ABenner Robert A · Meridian, IDS/N 22-513N1801PPayne David J · Eagle River, AKBuilt 1955 · S/N 22-2579N1804PVaughn James F · La Porte, INBuilt 1955 · S/N 22-2583N1805PSvendsen Jon A · Wasilla, AKBuilt 1955 · S/N 22-2584N1807PTempleton James N · Petersburg, ILBuilt 1955 · S/N 22-2586N1808PBistline Nephi K · Colorado City, AZS/N 22-2587N180DWWilliams J Darrell · Colbert, OKBuilt 1959 · S/N 22-7132N180EPPiper Aircraft Inc · Vero Beach, FLS/N 4496656N180MLBearden Harold H · Haleyville, ALBuilt 1961 · S/N 24-2609N1810PTurner Christian Millard · Eastsound, WABuilt 1955 · S/N 22-2589N1812PCarothers Edward L · Jersey Shore, PABuilt 1955 · S/N 22-2591N1813ALawrence Mark J · Rouses Point, NYS/N 22-516N1815ALa Viano Kenneth J · Westwood, NJBuilt 1952 · S/N 22-521N1819Peters Sean T · Oak Harbor, OHBuilt 1959 · S/N 22-6705N181FBaker Myron C · Morrow, OHRegistration revokedBuilt 1959 · S/N 226705N1823PGranger Joshua M · Rosebud, MTS/N 22-2603N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705N1827PMechel Emil C · Toledo, OHBuilt 1955 · S/N 22-2607N1829PBoll Ryan C · Sheboygan, WIBuilt 1955 · S/N 22-2609N1830AMurphy Joshua T · South Lyon, MIBuilt 1952 · S/N 20-873N1830PRegistered aircraftS/N 222610N1831PFay Bernard E · Eagle, AKBuilt 1955 · S/N 22-2611N1833PJones Brian K · Scituate, MABuilt 1955 · S/N 22-2613N1834PHellyer James R · Darien Center, NYBuilt 1955 · S/N 22-2614N1835PVintage Restorers Ltd LLC · Windsor, COS/N 22-2686N1836ABhl Aviation LLC · Denver, COBuilt 1952 · S/N 20-875N1838AGray Shane Charles · Interlochen, MIBuilt 1952 · S/N 22-529N1838PLarsen Steve J · Colton, ORBuilt 1955 · S/N 22-2618N1843PAdams James · Quinlan, TXBuilt 1955 · S/N 22-2623N1846PGrumpy Aviation Ltd · Denver, COBuilt 1955 · S/N 22-2628N184DGMartin Vicente Eduardo Misa · Miami, FLBuilt 1964 · S/N 27-2504N186SLJls Property Holdings LLC · Athens, TXS/N 23-236N186WWWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2004 · S/N 4496186N187TXXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496099N1890PParker Paul R · Summit Point, WVS/N 22-2632N1895PMurray James A · Wasilla, AKBuilt 1955 · S/N 22-2638N189ABAerial Banners Inc · Pembroke Pines, FLBuilt 1964 · S/N 25-2781N18DHHillegeist Tracy L · Beverly, KSBuilt 1956 · S/N 22-3855N18MWRed State LLC · Daytona Beach, FLBuilt 1967 · S/N 27-3691N18RJDocs Air LLC · Diamondville, WYS/N 27-4382N1900PHauff Delmar M · Julesburg, COBuilt 1955 · S/N 22-2647N1901PTurner William D · Southaven, MSBuilt 1958 · S/N 24-183N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103
Back to AD 85-02-05 R1