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.

N40RSSaul Gregory D Jr · Glenrock, WYBuilt 1960 · S/N 24-2031N40VKSimply Living LLC · Fort Myers, FLBuilt 1966 · S/N 24-4473N40VMQualitair LLC Trustee · MichelstadtS/N 30-113N40WFGrennell Brian M · Euless, TXS/N 30-971N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4109AMarc Inc · Bolton, MSBuilt 1970 · S/N 27-4459N410RABradley Aviation Group LLC · Van Nuys, CABuilt 1979 · S/N 27-7954097N410RMRegistered aircraftBuilt 1975 · S/N 36-7560084N4114KNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1966 · S/N 25-4043N4121PRiggin Flight Service Inc · Madison, SDBuilt 1959 · S/N 23-1601N412LClark Terry E · Dixon, MOBuilt 1954 · S/N 23-18N412PCHelmen Harry W · Ruckersville, VABuilt 1956 · S/N 22-4311N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610N41323Demars Kevin L · Fargo, NDS/N 36-7460001N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613N4136PN4136p LLC · Titusville, FLS/N 23-1617N4138PFreyburger Gregory P · Strykersville, NYBuilt 1959 · S/N 23-1619N413DPYale Companies LLC DBA · Fishers, INBuilt 2006 · S/N 4496234N4143PSparrowhawk Aviation · Manvel, TXBuilt 1959 · S/N 23-1624N4145PBlackhawk Holding Corp · Wilmington, DEBuilt 1959 · S/N 23-1626N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027N4153EGardner Gary A · Estherville, IABuilt 1979 · S/N 36-8002003N4153PHilty Robert · Wheatland, WYS/N 23-1637N4154EPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 36-8002004N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094N4170PIfa Aviation Inc · Wilmington, DEBuilt 1959 · S/N 23-1657N4177EAerial Banners North Inc · Pembroke Pines, FLBuilt 1978 · S/N 25-7856059N417BHHugel Bohdan · Selma, NCBuilt 1962 · S/N 24-3108N417EPEpic Aviation Inc · New Smyrna, FLFirst renewal noticeBuilt 2017 · S/N 4496403N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676N4189PAdams Carlos · Hawi, HIS/N 23-1677N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41AHHarding Kenneth H · Columbus, OHBuilt 1954 · S/N 22-1899N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N41LPulliam Oscar E Jr · Moscow, TNBuilt 1958 · S/N 24-351
Back to AD 85-02-05 R1