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.

N7307ZKrutson Wayne R · Tioga, NDS/N 25-2755N7308KBradley Gary C · Orchard Park, NYBuilt 1950 · S/N 20-217N7308ZKnutson Wayne R · Tioga, NDBuilt 1965 · S/N 25-3253N7309KStanley Bryan D · Paso Robles, CABuilt 1950 · S/N 20-218N7309PEvergreen Underground Water Conservation District · Pleasanton, TXS/N 24-2484N7309YGlaser William Burnett · New Smyrna Beach, FLS/N 30-296N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097N7311DRasmussen Kent L · Jetmore, KSBuilt 1957 · S/N 22-5099N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354N7311ZBermuda High Soaring School · Lancaster, SCBuilt 1965 · S/N 25-3258N7312DJenkins James L · Lake Stevens, WABuilt 1957 · S/N 22-5100N7312KWilson David A · Garrison, IABuilt 1950 · S/N 20-221N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356N7313ZSimmons Mark A DBA · Pawcatuck, CTBuilt 1965 · S/N 25-3245N7315DSkyhaven Airport Inc · Tunkhannock, PABuilt 1957 · S/N 22-5103N7316KSantucci John D · Boonton, NJBuilt 1950 · S/N 20-225N7316PCase Mark A Trustee · Shady Shores, TXBuilt 1961 · S/N 24-2492N7317YComanche Air Services LLC · Westminster, COBuilt 1964 · S/N 30-360N7318DAir & Field Equipment LLC · Moore, IDS/N 22-5106N7318YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 30-361N731UACherry Hill Aviation Inc · Freetown, INS/N 25-7405687N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989N7320YSpruce John P · Liberty Hill, TXBuilt 1964 · S/N 30-364N7321PTappan East LLC · New Philadelphia, OHBuilt 1961 · S/N 24-2498N7322DRainey William F III · Mt Pleasant, TNBuilt 1957 · S/N 22-5110N7322KBudd Douglas N · Crawford, NEBuilt 1950 · S/N 20-232N7322PRuple Michael D · Palm Bay, FLBuilt 1961 · S/N 24-2499N7323DWilkerson Dwight T · Kirkland, WABuilt 1957 · S/N 22-5111N7323PDurham Damon Patrick · Ripley, TNBuilt 1961 · S/N 24-2500N7323YFoster Jay W · Marshfield, MOBuilt 1964 · S/N 30-367N7324DRuach LLC · Wilmington, DES/N 22-5112N7324KBurley Joseph D · Fayetteville, GABuilt 1950 · S/N 20-230N7324PWright Havis L · Pleasant Hill, MOBuilt 1961 · S/N 24-2502N7324YMccaslin Dale Alan Trustee · Holt, MOBuilt 1964 · S/N 30-369N7325KMouton Charles J Jr · Gladewater, TXBuilt 1950 · S/N 20-233N7326DAllen Jason J · Benson, NCBuilt 1957 · S/N 22-5114N7326KSiebert Mark R · Monticello, MNBuilt 1950 · S/N 20-234N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371N7327DFrankfort Flying Club Inc · Beulah, MIBuilt 1957 · S/N 22-5115N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506N7328YBarnett David K · Brock, TXS/N 30-374N7329DCampbell Michael S · Ann Arbor, MIS/N 22-5117N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086N732UASonoran Aero LLC · Phoenix, AZBuilt 1968 · S/N 25-4658N7330KFinke Michael C · Sewickley, PABuilt 1950 · S/N 20-231N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509
Back to AD 85-02-05 R1