OpenAirDocs.org
AD 75-24-02

Registered aircraft · 8,499

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

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000N1007XD&R LLC · Emory, TXS/N 34-7570182N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216N101JKKaras Dean · Lansing, KSS/N 28R-7335243N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074N1024U24u Aviation LLC · Wilmington, DEBuilt 1971 · S/N 34-7250004N1027FFilarski Darryl M · Grosse Ile, MIBuilt 1971 · S/N 32-7140036N1029XBaden Frederick Richard · Mc Arthur, OHBuilt 1975 · S/N 32-7540181N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951N103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100N10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279N1049XValleyside Farm LLC · Woodstock, CTBuilt 1975 · S/N 32-7540132N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048N1054QTaylor Hauling II LLC · Laurel, MSBuilt 1977 · S/N 32-7740045N1054UDippolito Thaddeus M · Sherwood, ARBuilt 1971 · S/N 34-7250038N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195N1057XWeisenberger Thomas · Norwalk, OHBuilt 1975 · S/N 28-7505202N105DYYeager Daniel C · Iowa City, IABuilt 1966 · S/N 32-467N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015N1062UNathan John K · Seabrook, TXS/N 32-40070N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204N1069XEntelechy One LLC · Wichita, KSBuilt 1975 · S/N 32-7540134N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206
Back to AD 75-24-02