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.

N6126DNeal Brian C · Monrovia, CABuilt 1957 · S/N 22-4770N6126PDallas Jets Group LLC · Canton, TXBuilt 1959 · S/N 24-1226N6126ZKistler Stephen M · Monument, KSBuilt 1960 · S/N 25-147N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148N612EHIsland Flyers Inc · Addison, TXBuilt 1976 · S/N 277654161N612MRFladr LLC · Westfield, NJBuilt 1979 · S/N 27-8054008N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114N6130PHiga Bertram · Northridge, CAS/N 24-1230N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6135DHowe Bryan · Edgewater, FLBuilt 1956 · S/N 22-4779N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236N6137DPhelps Joe · Princeton, KYBuilt 1957 · S/N 22-4781N613FPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-45N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N6142DManbeck Michael R · Summerville, SCBuilt 1957 · S/N 22-4786N6144DCarter Tim R · Morgan, UTBuilt 1957 · S/N 22-4788N6145DLindsey Christopher T · Nesbit, MSBuilt 1957 · S/N 22-4789N6147DRegistered aircraftBuilt 1957 · S/N 22-4792N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366N614DPInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 447995119N614JDCc Aviation Inc · Tracy, CABuilt 1967 · S/N 30-1517N614RSecker David · San Jose, CAFirst renewal noticeBuilt 1964 · S/N 30-658N6150DPayne David J · Eagle River, AKS/N 22-4797N6150PCobb Berrien · Smyrna, GABuilt 1959 · S/N 24-1251N6151PRoberson Michael B · Winterville, NCBuilt 1959 · S/N 24-1252N6151ZRotor And Wing LLC · Tioga, NDBuilt 1960 · S/N 25-177N6152DFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 22-4799N6154DRoss Winn J III · Rochester, ILS/N 22-4801N6154PLonhart Donald E · Greeley, COBuilt 1959 · S/N 24-1255N6155DCurtis Jeremy A · Fairbanks, AKBuilt 1957 · S/N 22-4802N6155PSturm Steve G Trustee · Springdale, ARBuilt 1959 · S/N 24-1256N6157DBadinelli Ralph D · Blacksburg, VABuilt 1957 · S/N 22-4804N6157PFrazier Jon A · Vista, CABuilt 1959 · S/N 24-1258N6159DDavis James J · Beaver Dam, WIBuilt 1957 · S/N 22-4806N615ADontje Robert E · East Moline, ILS/N 22-18N6160PBbg Air Ventures LLC · Chandler, AZBuilt 1959 · S/N 24-1261N6162PKiester Michael E · Duncan, OKBuilt 1959 · S/N 24-1263N6163DBistline John A · Cedar City, UTBuilt 1957 · S/N 22-4810N6163PCommache Avn Inc · Flint, MIBuilt 1960 · S/N 24-1264N6164DSeligson Andrew · Tuckahoe, NYBuilt 1957 · S/N 22-4811N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383N6166BSides Michael E · Bartley, NEFirst renewal noticeBuilt 1979 · S/N 367960041N6166DClb LLC · Boerne, TXBuilt 1957 · S/N 22-4813N6167PRico Nathaniel J · Astoria, ORBuilt 1959 · S/N 24-1268
Back to AD 85-02-05 R1