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.

N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024N6492FSkywagon Aero LLC · Wilmington, DES/N 15063092N6492GState Of North Carolina · Raleigh, NCBuilt 2004 · S/N 18281411N6492HSpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700544N6492NOrmand Philip M · Tyrone, NMBuilt 1978 · S/N 21063066N6492TSkyway Aviation LLC · Port Jeff Sta, NYBuilt 1960 · S/N 17892N6492UWisber Peter F Jr · Perkasie, PABuilt 1979 · S/N U20605489N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404N6493AThornton Anthony D · Mckinney, TXBuilt 1956 · S/N 33293N6493BBoyd Ryan D · Stockton, CABuilt 1956 · S/N 29693N6493EJones Jeffrey Marlin · Westminster, MDBuilt 1984 · S/N 18268370N6493FHatcher Jess · Lehi, UTBuilt 1975 · S/N 18264202N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067N6493YNeed To Fly LLC · Yukon, OKBuilt 1981 · S/N 21064405N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657N6494ARoot Jeff G · Pound Ridge, NYBuilt 1956 · S/N 33294N6495AP Ponk Aviation · Camano Island, WABuilt 1956 · S/N 33295N6495BSanford George W Jr · Montross, VABuilt 1957 · S/N 29695N6495KBauknecht Daniel P · Antigo, WIBuilt 1975 · S/N 15077730N6495NBusiness Trip Corp Inc · Cape Coral, FLBuilt 1978 · S/N 21063069N6495TSale Reported · Tucson, AZSale reportedBuilt 1960 · S/N 17895N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661N6496BStartup Aviation Management LLC · Lakeway, TXBuilt 1957 · S/N 29696N6496FFisher Justin T · Lewes, DEBuilt 1975 · S/N 18264204N6496GJbm Aviation LLC · Mc Leansboro, ILS/N 15071996N64972Fixed Wing Holding Company Inc · Pembroke Pines, FLS/N 17275662N6497BVeve Rafael A · Indn Hbr Bch, FLBuilt 1957 · S/N 29697N6497EPeoples Mike · Rockwall, TXBuilt 1980 · S/N 18504050N6497GLynch David C · Columbus, INBuilt 1970 · S/N 15071997N6497TLane Leota P · Alexandria, OHS/N 17897N6497XPeebles Thomas O · Elma, WABuilt 1961 · S/N 18050997N6498BDunlap Paul C Jr · Rock Island, TNBuilt 1956 · S/N 29698N6498ECallender Roy A Jr · Ennis, TXBuilt 1959 · S/N 46598N6498FWisener Randall G · Addison, ALBuilt 1979 · S/N 17273232N6499ATreetop Flying Circus LLC · Niceville, FLBuilt 1956 · S/N 33299N6499BMoore Thomas W · Zimmerman, MNFirst renewal noticeBuilt 1957 · S/N 29699N6499EAzevedo Manuel J · Modesto, CABuilt 1959 · S/N 46599N6499FMacintosh William J · Simpsonville, SCBuilt 1975 · S/N 18264207N6499GSkadberg Christen G · Knife River, MNBuilt 1970 · S/N 15071999N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073N649ARSmith Roy Dennis · Buckeye, AZBuilt 1959 · S/N 55953N649CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N 18282282N649DHHale Mfg LLC · Wilmington, OHBuilt 1998 · S/N 18280142N649ESFlymore Aviation LLC · Philadelphia, PABuilt 1975 · S/N 172-64536N649GCAviation Paradise LLC · Homestead, FLBuilt 1979 · S/N 17273413N649TLamonds Donald · Advance, NCBuilt 1998 · S/N 18280261N649TCSpartan Education Group LLC · Tulsa, OKBuilt 2000 · S/N 172S8649
Back to AD 79-10-14 R1