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.

N6358FHarrison Zuzana · Albuquerque, NMBuilt 1975 · S/N 18264172N6358SStancil Joseph E Jr · Eagle River, AKBuilt 1982 · S/N U20606557N63595Beard Bruce H · Pocatello, IDBuilt 1977 · S/N 18052856N63596Parke Helen M · Kent, WABuilt 1975 · S/N 15077416N63598Hollrah Richard E · Enid, OKBuilt 1975 · S/N 15077417N63599Burkel Robert G · Hemet, CABuilt 1975 · S/N 15077418N6359ASutton Aircraft Salvage LLC · Palmer, AKBuilt 1956 · S/N 33159N6359BRoss Stout Architect Inc · Indian Wells, CABuilt 1978 · S/N 21062749N6359DFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17272745N6359KMaierhoffer Henry F DBA · Sylvania, GABuilt 1975 · S/N 15077662N635BASvetfur Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11596N635BKGuilford County · Greensboro, NCBuilt 2003 · S/N 172S9554N635CGLongstreth James E · Powhatan, VAS/N 18265386N635CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281530N635CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11461N635CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283335N635MSpl Invest LLC · Chandler, AZBuilt 1964 · S/N 17252253N635NDEveryday Airman LLC · Seattle, WABuilt 2013 · S/N 172S11294N635SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8630N63605Lowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1975 · S/N 15077423N63608Klug Brian V · Speonk, NYBuilt 1975 · S/N 15077425N63609Filtenborg Daniel · Shelbyville, MIBuilt 1981 · S/N 17275455N6360AClaiborne Howard · Cottonwood, CABuilt 1956 · S/N 33160N63610Frantz Paul · Palmyra, PABuilt 1975 · S/N 15077426N63612St Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1981 · S/N 17275456N63617Johnston Daniel · Virginia Beach, VAS/N 15077432N63619Beard Jeffrey L · New Oxford, PABuilt 1975 · S/N 15077434N6361FTramper Air LLC · Rockford, MIBuilt 1966 · S/N 337-0361N6361GHalley Dan R · Avery, TXBuilt 1970 · S/N 15071861N6361SSchade Scott · Green Valley, AZBuilt 1967 · S/N 15067161N63620Florida Airplane Recovery LLC · Tallahassee, FLS/N 15077435N63621Macgregor Sinclair · Oroville, CAS/N 15077436N63626Nelson Matthew J · Frewsburg, NYS/N 15077439N63628Black Hills Airplanes LLC · Rapid City, SDBuilt 1981 · S/N 17275458N6362AMillican Clifford A · Burleson, TXBuilt 1979 · S/N 21063523N6362BSimplot Don J · Boise, IDFirst renewal noticeS/N 34262N6362EYoungblood Harley O III · Vancouver, WABuilt 1959 · S/N 46462N6362FCabral Nicholas · Oldsmar, FLBuilt 1966 · S/N 337-0362N6362SMott Charles A Jr · Chesapeake, VABuilt 1967 · S/N 15067162N63632Prestige Air Charter Inc · Sandston, VABuilt 1975 · S/N 15077442N63637Oclair Justin B · New Canada, MES/N 15077445N63638Skywagon LLC · Wilmington, DES/N 18052858N6363AWong Adrian Trustee · San Francisco, CABuilt 1956 · S/N 33163N6363EHanson Douglas L · Montpelier, VTBuilt 1959 · S/N 46463N6363GGillis Timothy L · Kenai, AKBuilt 1970 · S/N 15071863N6363KKnoblock Stephen A · Acworth, GABuilt 1976 · S/N R1722041N6363SSnell Matthew L · Ackerly, TXS/N 15067163N63641Cole Warren G · Watkinsville, GABuilt 1975 · S/N 15077448N63645Greene Roswell J · Punta Gorda, FLBuilt 1975 · S/N 15077451N63646Reed Phillip · Lanesboro, MNS/N 15077452
Back to AD 79-10-14 R1