AD 79-10-14 R1

Registered aircraft · 56,582

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-14-R1')
    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-14-R1')
  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.

N75837Linder Ronald G · Fort Wayne, INBuilt 1976 · S/N 17267992N75838Fadel Shaheen J · Charlotte, NCS/N 17267993N75839Rocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1976 · S/N 17267994N7583GPebworth Properties LLC · Auburn, WABuilt 1970 · S/N 17259283N7583KBaker Mark L · Murfreesboro, TNBuilt 1976 · S/N 18052682N7583SAir Anderson LLC · Dubuque, IABuilt 1976 · S/N 18265232N7583UMcgilvray Jerry Alan · Clayton, ALBuilt 1975 · S/N 15077750N7583XGreene Bryan V · Turlock, CABuilt 1960 · S/N 17248083N75840Planebros LLC · Bixby, OKBuilt 1976 · S/N 17267995N75842Foree John Baird · New Castle, KYBuilt 1976 · S/N 17267997N75844Command Aviation Inc · Bellingham, WABuilt 1976 · S/N 17267998N75845Stark Russell Allen · Madison, WIBuilt 1976 · S/N 17267999N75846Rodgers Lynn C · Springfield, MOBuilt 1976 · S/N 17268000N7584MPecotte Harry A · Silver City, NMBuilt 1959 · S/N 55884N7584NCarto Flight Inc · Willoughby, OHBuilt 1977 · S/N U20603689N7584SSanderson Jerome A · Fort Worth, TXBuilt 1976 · S/N 18265233N7585EKauffman Larry R · Auburn, WABuilt 1984 · S/N 18268383N7585GCessna85g LLC · Manassas, VABuilt 1970 · S/N 17259285N7585SHayes John Martin · Mcalester, OKBuilt 1976 · S/N 18265234N7585TBustamante Luis E · Longview, TXBuilt 1959 · S/N 47185N7585UMoody Joshua Michael · Springfield, ORBuilt 1975 · S/N 15077752N7585VMollahan Joseph P · Yamhill, ORBuilt 1976 · S/N 177RG0876N75860Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 1976 · S/N 17268005N75866Gibson Aviation Services LLC · Menomonie, WIBuilt 1976 · S/N 17268009N7586MStar Valley Aviation Club LLC · Afton, WYBuilt 1959 · S/N 55886N7586VSchroeder Terry E · Tuscola, ILBuilt 1976 · S/N 177RG0877N75870Westwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700648N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012N75875Schumacher Matthew · Wenatchee, WAS/N 18877N75876Roe Amber · Scotts Valley, CABuilt 1976 · S/N 17268013N75878Milosevich Nikola · Deland, FLBuilt 1976 · S/N 17268014N75879Griffin Aviation LLC · Spokane, WABuilt 1976 · S/N 17268015N7587SWerner Matthew J · Shiner, TXS/N 18265236N7587TStreater Stephen · Palm Coast, FLBuilt 1959 · S/N 47187N7587VBradley Vaylan L · Keller, TXBuilt 1976 · S/N 177RG0878N7587XBrown Bomber LLC · Missoula, MTS/N 17248087N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019N7588MRucinski Edward A · Climax, NCS/N 55888N7588SPeraro Thomas A · Brighton, COBuilt 1979 · S/N R1723281N7588TSale Reported · Orlando, FLSale reported, pending cancellationBuilt 1960 · S/N 47188N75890Milligan Tony L · Rumford, MEBuilt 1976 · S/N 17268020N75897Gopalakrishnan Sanjeev K · Spring, TXBuilt 1976 · S/N 17268023N75898Center O Flying Club · Tumwater, WABuilt 1976 · S/N 17268024N7589DBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17272927N7589VCorwin Lloyd D · Idaho Falls, IDBuilt 1976 · S/N 177RG0880N758AASager Joseph M · Milford, PABuilt 1978 · S/N R1722931N758ABBaerwolf Roy · Lake Havasu City, AZBuilt 1978 · S/N R1722938N758AFSims Hollow M · Lithonia, GABuilt 1978 · S/N R1722936N758AJHolman David · Bishop, CABuilt 1978 · S/N R1722939
Back to AD 79-10-14 R1