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.

N6076DPinnow Andrew W · Cheshire, CTBuilt 1956 · S/N 22-4730N6077DPargman Curtis A · Big Lake, MNBuilt 1957 · S/N 22-4731N6078DWagar Dennis Murphy · Marion, MTBuilt 1957 · S/N 22-4732N6079PColson Carl L · Blunt, SDBuilt 1959 · S/N 24-1177N6079ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-91N6084CBig Bend Community College · Moses Lake, WABuilt 2008 · S/N 4496267N6084DCsapos Larry G · Ovid, MIBuilt 1957 · S/N 22-4738N6085YPharmair LLC · Jackson, MSBuilt 1966 · S/N 27-3287N6087PBrandner Paul D · Lake Tapps, WABuilt 1959 · S/N 24-1186N6088DSale Reported · Langley, WASale reportedBuilt 1956 · S/N 22-4742N6089DHoyt William C · Trimble, MOBuilt 1956 · S/N 22-4743N6089PMichaelsen Richard P · Sanborn, NYBuilt 1959 · S/N 24-1188N6089YAerosavant LLC · Towanda, PABuilt 1966 · S/N 27-3295N6090PBasin Franchising LLC · Vernal, UTBuilt 1959 · S/N 24-1189N6092YClean Waste Solutions LLC · Indianapolis, INBuilt 1966 · S/N 27-3298N6097PGuest Aviation LLC · Crane Hill, ALBuilt 1959 · S/N 24-765N60CSAir Flight Enterprises Inc · South Daytona, FLBuilt 1958 · S/N 24405N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544N60RBShrode Rafe C · Jewett, TXBuilt 1955 · S/N 22-2761N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N60WUWsu Campus Of Applied Sciences And Technology · Wichita, KSBuilt 2025 · S/N 4496615N6100DSzostak Edward M · San Diego, CABuilt 1956 · S/N 22-4744N6101DHanson John A · Molena, GABuilt 1957 · S/N 22-4745N6101PLockett Terrell M Sr · Winter Haven, FLBuilt 1959 · S/N 24-1199N6102DHutchins Chad M · Colorado Springs, COS/N 22-4746N6102PAllen Darren Kerr · Thomasville, GABuilt 1959 · S/N 24-1200N6104DLehrman Ronald L · Brownsburg, INS/N 22-4748N6104PKimsey Thomas W · Warner Robins, GABuilt 1959 · S/N 24-1202N6106PRegistration Pending · Mesa, AZRegistration pendingBuilt 1959 · S/N 24-1204N6107DStephen Benjamin G · Egg Harbor, WIBuilt 1956 · S/N 22-4751N6111DAdventure Flight LLC · Duchesne, UTBuilt 1956 · S/N 22-4755N6112PBurnett Jennifer · Palmer, AKS/N 24-1212N6112ZLowry Wilson R · Leonardtown, MDBuilt 1960 · S/N 25-130N6114PCompton Mark E · Garfield, KYBuilt 1959 · S/N 24-1214N6115DGeske Robert L · Enderlin, NDBuilt 1956 · S/N 22-4759N6118DAtkinson James A · Bouse, AZBuilt 1957 · S/N 22-4762N6118PNovak Mark S · Dawson, NEBuilt 1959 · S/N 24-1218N6119DMeyer Robert M · Lancaster, NYBuilt 1956 · S/N 22-4763N6119PModisette Jeremy W · Baldwin, GABuilt 1959 · S/N 24-1219N611SGRph Engineering LLC · Lehi, UTBuilt 1979 · S/N 27-8054020N611VProtain Jaden · Reno, NVBuilt 1959 · S/N 24-968N611WWCone S E Jr · Hobbs, NMBuilt 1978 · S/N 277854093N6120PDremel Ronald W · North Bend, PABuilt 1959 · S/N 24-1220N6120ZH & H Ag Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-140N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332N6123DCampi Curtis · Boulder City, NVBuilt 1957 · S/N 22-4767N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145
Back to AD 85-02-05 R1