OpenAirDocs.org
AD 80-17-04

Registered aircraft · 3,690

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:80-17-04')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-17-04')
  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.

N1001JBowmar Bruce C · Oxnard, CAS/N 24-3095N1003FChyatte Douglas · Saint Joseph, MOBuilt 1981 · S/N 24-1161N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291N1006WFadem Justin Andrew · Williamsville, NYBuilt 1980 · S/N 24-1069N10074Linder Matthew L · Kalkaska, MIS/N 24-3096N1007NNewberg Edgar T · Hector, MNBuilt 1981 · S/N 24-1098N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100N1008LWilson Jeffrey M · Upper Arlington, OHBuilt 1981 · S/N 24-1103N1009CFord Richard B · Hendersonville, NCBuilt 1981 · S/N 24-1105N100AZNnww Holdings LLC · San Angelo, TXS/N 421C1051N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623N100HMSchultz David J · Neenah, WIBuilt 1978 · S/N 340A-0559N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669N100LCozumel Leasing LLC · Wilmington, DEBuilt 1977 · S/N 421C0313N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526N100YVPalmy LLC · Lander, WYBuilt 1991 · S/N 243194N1010ARussell Jerald Trustee · Pampa, TXBuilt 1988 · S/N 24-3079N1010GHyde Kinder · Montgomery, ALBuilt 1989 · S/N 24-3098N1013USiry Stanley A · Burke, VAS/N 24-3101N10143Fatdog LLC · Voorhees, NJBuilt 1981 · S/N 24-1107N1014UStubblefield Daniel R · Lake Havasu City, AZS/N 24-3106N1015SJacobs Forest R · Vero Beach, FLS/N 24-3107N10162Crespi Tony D · Meriden, CTBuilt 1981 · S/N 25-0561N10165N10165 Corp Trustee · Wilmington, DEBuilt 1981 · S/N 25-0562N10167Sterling Air LLC · La Quinta, CABuilt 1981 · S/N 25-0563N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727N1017FImwalle John N · Batavia, OHS/N 24-3108N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564N1018CSotek LLC · Cheyenne, WYS/N 24-1110N1018MWilliams Arthur L · Amherst, OHBuilt 1990 · S/N 24-3153N10194N10194 Aviation LLC · Pleasant Hill, CAS/N 24-3109N101ECAtkinson Justin Shane · Fairbanks, AKBuilt 1978 · S/N 24-0593N101KUBarton Bruce R · Richmond, KYBuilt 1979 · S/N 24-0778N101MURed Bird And Outlaw LLC · Schertz, TXBuilt 1994 · S/N 24-3335N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631N1021KVranjes Miron · Mercer Island, WAS/N 24-3104N1024CLarsen Johannes · Sterling, MAS/N 24-1113N1026NMartin Jonathan W · Carnesville, GABuilt 1994 · S/N 24-3337N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215N1029BStonewall Aviation LLC · Stillwater, OKBuilt 1982 · S/N 24-1336N102ATEpling Bryan J · Upper Arlington, OHBuilt 1981 · S/N 24-1217N102PLLenker Mark R · Grand Prairie, TXBuilt 1991 · S/N 24-3233N102WCDac 2020 Inc · Skaneateles, NYBuilt 1978 · S/N 340A0443
Back to AD 80-17-04