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.

N61157Bravo Holdings LLC · St Francis, WIBuilt 1969 · S/N 15070846N61158Robert N Shadduck Inc · Annandale, MNBuilt 1980 · S/N 18504115N61159Stenger D James Trustee · Sonora, CABuilt 1969 · S/N 15070847N6115TIngegno Frank N · Carmel, INS/N 15060815N61163Miller William M · Enterprise, KSBuilt 1969 · S/N 15070851N61164Brydon Robert J · Lago Vista, TXBuilt 1980 · S/N 18504117N61166Om Air LLC · Saint Louis, MOS/N 15070852N61168Sherwood Ronald R · Kathleen, GABuilt 1969 · S/N 15070854N6116GWilbur David W · Marlow, NHBuilt 1969 · S/N 15071616N6116RAirxn LLC · Williams, AZBuilt 1965 · S/N T210-0016N6116YSaab35 Draken Inc · Pocono Pines, PAS/N 21064256N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602N61172Celeste Nash · Vista, CAS/N 15070858N61176Closson Dennis L · Red Wing, MNBuilt 1969 · S/N 15070862N61177Spenner John T · Fenton, MOBuilt 1969 · S/N 15070863N61178Seman Kenneth H · Ravenna, OHBuilt 1969 · S/N 15070864N6117EViveros Ezequiel · Calexico, CABuilt 1983 · S/N 18268346N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017N6117NTaylor Willis P III · Suffolk, VABuilt 1980 · S/N 18267790N61182B2 W Corporation · Winona, MNBuilt 1969 · S/N 15070867N61184Lawson Gary R · Olympia, WAS/N 15070869N61186Petit Leon · Virgil, ILBuilt 1969 · S/N 15070871N61187Registration Pending · Burleson, TXRegistration pendingBuilt 1969 · S/N 15070872N61189Orr Jeffrey N · Waco, TXBuilt 1969 · S/N 15070874N61190Freed Richard H · Watervliet, MIBuilt 1969 · S/N 15070875N61192Possemato Domenic · Lincoln, NHS/N 15070877N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N6119BHeart Mountain Aviation Services LLC · Knoxville, IABuilt 1957 · S/N 34119N6119EBliss Richard F · Talladega, ALS/N 46219N611BDClement Aviation Inc · Tea, SDS/N 17266692N611CKovalesky James · Clayton, NCBuilt 1955 · S/N 26895N611CAWilliams Todd A · Littleton, COBuilt 1977 · S/N 17269022N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611EAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1979 · S/N 17272471N611EKWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10282N611GDufriend Daren P · Payson, AZS/N 33587N611GGPence Edward R · Bakersfield, CABuilt 1979 · S/N R1723110N611HPFlorida Highway Patrol · Tampa, FLFirst renewal noticeBuilt 2006 · S/N 18281873N611JFKeller Robert W · Racine, WIS/N 15077427N611KHWolf Ronald T · Abbeville, LAS/N 15074824N611MGIsr Platforms LLC · Mclean, VABuilt 1967 · S/N 337M0081N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911N611SAAda Forestry Division · Malvern, ARBuilt 1976 · S/N 18265295N611SFWood Automotive Inc · Cropwell, ALBuilt 2023 · S/N 18283224N611TMWest Michigan Skybirds Inc · Battle Creek, MIBuilt 1978 · S/N 21063037N611WJDiamondtooling Inc · Wilmington, DEFirst renewal noticeBuilt 1975 · S/N 18264334N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134N61205Lockhart Aero LLC · Austin, TXBuilt 1969 · S/N 15070886N61206Hahlbohm Jeffrey S · Helena, MTS/N 15070887N61207Desroches John · Scottsdale, AZS/N 15070888
Back to AD 79-10-14 R1