OpenAirDocs.org
AD 84-10-01 R1

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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.

N735ULStraughn Matthew · Glenn Dale, MDBuilt 1977 · S/N 18265694N735UPSummitt Aviation LLC · Lake Mary, FLBuilt 1977 · S/N 18265697N735UQSkylane One LLC · Columbus, OHS/N 18265698N735URDavis Howard R · Greenwood, MSS/N 18265699N735UVFly-In LLC · Spanish Fort, ALBuilt 1977 · S/N 18265703N735UYAlexander Mark R · Waunakee, WIS/N 18265706N735VAWaggoner David F Trustee · Aurora, ORS/N 18265708N735VBShogry Louis M III · Lee, MAS/N 18265709N735VCTalbott Tom · Tempe, AZBuilt 1977 · S/N 18265710N735VFSheffels James · Great Falls, MTBuilt 1977 · S/N 18265713N735VHKcsi Aerial Patrol Inc · Bakersfield, CAS/N 18265715N735VKWelge Jack H Jr · Longview, TXBuilt 1977 · S/N 18265717N735VLAnderson William R · Overland Park, KSBuilt 1977 · S/N 18265718N735VMMorris Dale L · Yelm, WABuilt 1977 · S/N 18265719N735VPMpc Aviation LLC · Homestead, FLBuilt 1977 · S/N 18265721N735VSFrench Steve · Jupiter, FLBuilt 1977 · S/N 18265724N735VVBw LLC · Denver, COBuilt 1977 · S/N 18265727N735VXRicupero Gary T Trustee · Monterey, CAS/N 18265729N735WAPiro Anthony Michael · Groveland, CABuilt 1977 · S/N 18265732N735WGWilliford Jason R · Randlett, OKBuilt 1977 · S/N 18265738N735WHTwining David S · Corvallis, ORBuilt 1977 · S/N 18265739N735WKRomper Aviation LLC · Boise, IDBuilt 1977 · S/N 18265741N735WLScott Lindsey · Toledo, WABuilt 1977 · S/N 18265742N735WMHolland John E Trustee · Sharon Center, OHS/N 18265743N735WRHuizenga Bruce A · Waupun, WIS/N 18265747N735WTBlack Timber Industrial LLC · Silt, COBuilt 1977 · S/N 18265749N735WUCarter Gary James · Manlius, NYBuilt 1977 · S/N 18265750N735WWRegistered aircraftBuilt 1997 · S/N 18280005N735XEMant Thomas A · Diamond Springs, CABuilt 1977 · S/N 18265760N735XFAlabama Aircraft Management LLC · Valley Head, ALBuilt 1977 · S/N 18265761N735XHTippair Inc · West Lafayette, INBuilt 1977 · S/N 18265763N735XMHansen Michael J · Marysville, WABuilt 1977 · S/N 18265767N735XSCarbajal Juan Luis Sr · Gualala, CABuilt 1977 · S/N 18265772N735XTVentura Aviation LLC · Emerald Isle, NCBuilt 1977 · S/N 18265773N735XVGps Land Company LLC · Brandon, MSBuilt 1979 · S/N U20604980N735XZRegistered aircraftS/N 18265779N735YAMinnillo Vincent C · Ocala, FLBuilt 1977 · S/N 18265780N735YBRaulerson James · Holland, MOBuilt 1977 · S/N 18265781N735YCLindsay Stephen J · Middletown, NYBuilt 1977 · S/N 18265782N735YGGiacomet Mauro · Portage, MIBuilt 1977 · S/N 18265786N735YJDuluth Ang Flying Club Inc · Cloquet, MNBuilt 1977 · S/N 18265788N735YLBlue Skies Aviation LLC · Lansing, MIBuilt 1977 · S/N 18265790N735YRGibbs Phillip G · Dubuque, IABuilt 1977 · S/N 18265795N735YTVenturini Renato A Jr · Friendswood, TXBuilt 1977 · S/N 18265797N735YUObrien Daniel Joseph · Woburn, MABuilt 1977 · S/N 18265798N735YVSmith Gary L Sr · Monrovia, MDBuilt 1977 · S/N 18265799N735YWKershner William C · Sewanee, TNBuilt 1977 · S/N 18265800N735YXKrm Aviation LLC · Dahlonega, GABuilt 1977 · S/N 18265801N735YYR & B Aviation LLC · Rogers, ARBuilt 1977 · S/N 18265802N735YZChism Benjamin H · Elk City, KSBuilt 1977 · S/N 18265803
Back to AD 84-10-01 R1