OpenAirDocs.org
AD 78-25-03

Registered aircraft · 5,259

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:78-25-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:78-25-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.

N1007LPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-7703403N1007XD&R LLC · Emory, TXS/N 34-7570182N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010N1010YGregory 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-7535216N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057N101JKKaras Dean · Lansing, KSS/N 28R-7335243N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475N101PLHay William G Jr · Gualala, CAS/N 27-7754156N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483N102TMJunior Fernando Sporleder · Sarasota, FLBuilt 1976 · S/N 31-7712015N102WHStuddiford James A · Lithia, FLS/N 31-7952066N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195N1056HBrown Danny Joe · Skidmore, MOS/N 28R-7703011N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419N105MAMorrison Andrew · Haverford, PABuilt 1980 · S/N 31T-8104015N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416N106PESheboygan Flying Club LLC · Sheboygan, WIBuilt 1977 · S/N 28R-7837088N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199
Back to AD 78-25-03