OpenAirDocs.org
AD 85-24-03

Registered aircraft · 5,326

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-24-03')
    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-24-03')
  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-1105N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526N100TEBlaney Robert L · Newark, OHBuilt 1975 · S/N 22-1255N100YVPalmy 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-3106N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255N1015SJacobs 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-3335N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887N101UKInternational 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-3233N102YMKern Jason S Trustee · New Braunfels, TXBuilt 1996 · S/N 24-3389N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216N1036USandor Pethes · Terre Haute, INBuilt 1996 · S/N 24-3386N1038WMulrooney Brian P · Minnetonka, MNBuilt 1981 · S/N 24-1118N1039BG & M Aviation LLC · Kokomo, INBuilt 1981 · S/N 24-1119N1039KMorris Eric K · Strasburg, VAS/N 24-3110
Back to AD 85-24-03