OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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

N7371WVista I Inc · Smithville, OHBuilt 1963 · S/N 28-1253N73726Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267630N73728Crowe Robert B · Del Valle, TXBuilt 1976 · S/N 17267632N7372JMccabe Colin · Frisco, TXBuilt 1968 · S/N 28-24727N73732Midway Capital Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267634N7373DKramer William L · Big Lake, AKBuilt 1952 · S/N 18-5738N7373GJones Stonie C · Crescent City, FLS/N 3739N7373WColvin Michael E · Monroe, WIBuilt 1963 · S/N 28-1255N73744Fca Flight Center Inc · Fitchburg, MABuilt 1976 · S/N 17267643N7374DBig E LLC · Lemoore, CABuilt 1979 · S/N 17272918N7374EWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1978 · S/N 17272098N7374PFerland Jeffrey B · San Francisco, CABuilt 1961 · S/N 24-2555N73753Stick And Rudder Club Inc · Waukegan, ILBuilt 1976 · S/N 17267652N73754Weninger Mark J · Maize, KSBuilt 1976 · S/N 17267653N73755Lima 001 LLC · Muscatine, IABuilt 1976 · S/N 17267654N7375CErick Enterprises LLC · Spreckels, CABuilt 1969 · S/N 28-25634N7375DWright Joesph W · Eagle River, AKBuilt 1957 · S/N 18-5740N7375GAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1970 · S/N 17259075N7375JRegistered aircraftBuilt 1968 · S/N 28-24731N7375KFairchild Maxwell D · Morristown, TNBuilt 2024 · S/N 60384N7375PSmith Happy E · Rogersville, TNBuilt 1961 · S/N 24-2556N7375WSims Phillip · Titusville, FLS/N 28-1257N73761Spring City Aviation Inc · Waukesha, WIBuilt 1976 · S/N 17267658N73764White David W · Woodland, WAS/N 17267661N73768Flighttime Inc · Wiscasset, MEBuilt 1976 · S/N 17267664N73769Canino Enterprises Inc · Miami, FLBuilt 1976 · S/N 17267665N7376DZimmer Chris P · Upham, NDBuilt 1957 · S/N 18-5741N7376WButtercup Express LLC · Woodward, OKBuilt 1963 · S/N 28-1278N73776Seebold Jdustin K · Mifflinburg, PABuilt 1976 · S/N 17267670N7377JKlinginsmith Randal L · Kearney, NEBuilt 1968 · S/N 28-24740N7377WMorris Vaughan · Weatherford, TXBuilt 1963 · S/N 28-1259N73784Dsr Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17267676N73785Sierra Sky Aviation LLC · Whitefish, MTBuilt 1976 · S/N 17267677N73786Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267678N73787Pegasus Flying Club LLC · Mccordsville, INS/N 17267679N7378WTribuno Michael G · Rosamond, CABuilt 1963 · S/N 28-1360N73790Jimenez Carlos A · Davie, FLBuilt 1976 · S/N 17267682N73794Clifton Jack D · La Junta, COBuilt 2002 · S/N 001N73798Lowry Steve · Sun River, MTBuilt 1976 · S/N 17267688N73799Sojak Therin F · Harlingen, TXBuilt 1976 · S/N 17267689N737AAHogan Thomas A · Fairfield, OHBuilt 1977 · S/N 17269258N737ACU56fliers LLC · Idaho Falls, IDBuilt 1977 · S/N 17269260N737AEBluewater Airmotive Corp · Wilmington, DEBuilt 1977 · S/N 17269262N737AFApm Leasing LLC · Casper, WYS/N 17269263N737AKHouse Alan D · Mesa, AZS/N 2282N737ALRegistration Pending · Homer, AKRegistration pendingBuilt 1977 · S/N 17269268N737AMCalifornia Aviation Services Inc · Riverside, CABuilt 1977 · S/N 17269269N737AWFinland Leasing Co Inc · Quakertown, PABuilt 1977 · S/N 17269277N737AYMoeller Dakota J · West Point, IABuilt 1977 · S/N 17269279N737BBHaughey Mathew · Celebration, FLBuilt 1977 · S/N 17269282
Back to AD 79-10-03 R2