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.

N7330SNew Heights Aviation LLC · Decatur, TXBuilt 1976 · S/N 18265121N7330TBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1959 · S/N 46930N73311184 Flying Club Inc · Concord, CABuilt 1976 · S/N 17267364N73312Murray Air LLC · Patoka, ILBuilt 1976 · S/N 17267365N73317Bell Susan J · Georgetown, CABuilt 1976 · S/N 17267368N73318Lair De Rien Aviation Inc Trustee · Wilmington, DEBuilt 1976 · S/N 17267369N73319My Way Aviation LLC · Weston, FLBuilt 1976 · S/N 17267370N7331AAviation 98374 LLC · Bonney Lake, WABuilt 1957 · S/N 29431N7331NLost Creek Aviation LLC · Elkhorn, WIBuilt 1974 · S/N 18263115N7331QKelly Timothy K · Dassel, MNBuilt 1972 · S/N 18260971N7331SAzizi Habib E · Franklin, TNBuilt 1976 · S/N 18265122N7331TRothenberger Stanley D · Topeka, KSS/N 46931N7331UBristol Bay Air Service Inc · Dillingham, AKBuilt 1977 · S/N 20700402N7331XPorter H Tom · Columbia, MSS/N 15059431N73321Learn To Fly Nola LLC · New Orleans, LABuilt 1976 · S/N 17267372N73324Gulf Atlantic Airways DBA · Gainesville, FLBuilt 1976 · S/N 17267374N7332MNorthern Flyers LLC · Bemidji, MNS/N 55632N7332SSmith Enterprises Inc · Grangeville, IDBuilt 1976 · S/N 18265123N73330Thornton Ralph · Oxford, ALBuilt 1976 · S/N 17267378N73331Dameron Cleveland F · Wicomico Church, VABuilt 1976 · S/N 17267379N73334Heavy Metal Air LLC · Farmingdale, NYBuilt 1976 · S/N 17267382N73338Einarson Flying Service · Intl Falls, MNS/N 17267386N7333FHickle William H · Inyokern, CAS/N 17273246N7333QMac Neill Malcolm G · Lake Junaluska, NCBuilt 1972 · S/N 18260973N7333TMyl High Flying Club LLC · Mccall, IDFirst renewal noticeBuilt 1959 · S/N 46933N73345N73345 Aviation LLC · Sheridan, WYBuilt 1976 · S/N 17267390N7334FWings Flight Enterprises Inc · Danville, KYBuilt 1979 · S/N 17273247N7334GEllis Gregory D · Winnsboro, TXBuilt 1970 · S/N 17259034N7334KFlying Wet Dog LLC · Marshall, TXBuilt 1976 · S/N R1722058N7334NRobles James J · Oro Valley, AZBuilt 1976 · S/N U20603616N7334QHurri-Clean LLC · Brewton, ALBuilt 1972 · S/N 18260974N7334SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1976 · S/N 18265125N7334THunter Jeffrey D · Wolfforth, TXBuilt 1959 · S/N 46934N7334XElliott Frank F · Mojave, CABuilt 1961 · S/N 15059434N73354Sky Partners LLC · Sylacauga, ALBuilt 1976 · S/N 17267396N73357Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 17267398N7335APomeroy Keith R · Port Saint Lucie, FLS/N A1500721N7335GJordan Jeffrey B · Woodland, WABuilt 1970 · S/N 17259035N7335NEnrique Elias Luis · Chandler, AZS/N 21063221N7335QStaas Justin W · Sacramento, CABuilt 1972 · S/N 18260975N7335XTowery Katy L · Dover, DES/N 15059435N73361Snyder Steven S · Norfolk, VABuilt 1976 · S/N 17267400N73362Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17267401N73365Toliver David R · Lenexa, KSS/N 17267404N73367Martinez Jose Antonio · Orlando, FLBuilt 1976 · S/N 17267406N7336ARanger Aviation Inc · Burlington, COBuilt 1957 · S/N 29436N7336CDelta Kilo Av8 LLC · Bonita Springs, FLS/N 21063938N7336HGerace William L · Anchorage, AKBuilt 1977 · S/N 18503366N7336MYates Christopher Lynn · Edmond, OKS/N 55636N7336NRoberts Frederick · El Segundo, CABuilt 1974 · S/N 18263120
Back to AD 79-10-14 R1