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.

N5963BJones Damon · Lafayette, ORBuilt 1956 · S/N 33963N5963GInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 15071463N5963TKnight Luke O · Monroe, IAS/N 15060663N5964ABeachy Matthew · Russellville, KYBuilt 1956 · S/N 28564N5964BBailey Steven W · Puyallup, WABuilt 1956 · S/N 33964N5964TColburn Shawn M · Monroe, GABuilt 1964 · S/N 15060664N5965BMathison John M · Vancouver, WABuilt 1956 · S/N 33965N5965GCavu Pilot LLC · Powell, TNS/N 15071465N5965JI & U Aviation LLC · Lexington, SCS/N A1500265N5965TJones Robert · Gulf Breeze, FLBuilt 1964 · S/N 15060665N5966AHutchins Charles Norman · Wildomar, CAS/N 28566N5966BLemaster Roxanne · Brookville, OHBuilt 1956 · S/N 33966N5966EHowe Allen R · Waterloo, WIS/N 17466N5966JWydronek Joseph A · Tucson, AZBuilt 1975 · S/N 18263590N5967BKelley William P · Herron, MIBuilt 1956 · S/N 33967N5967ERegistration Pending · Winter Haven, FLRegistration pendingBuilt 1959 · S/N 17467N5968BLawrence Jon D · Williamsburg, MIBuilt 1957 · S/N 33968N5968JAragon Cecilia R · Sequim, WABuilt 1971 · S/N A1500268N5969ANichols Patricia · Varnado, LABuilt 1956 · S/N 28569N5969EFithian Michel · Putnam Valley, NYBuilt 1959 · S/N 17469N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969N5969RFrederick Clint A · Mattoon, ILBuilt 1965 · S/N 17253638N596CSVan Anda Aviation LLC · Apopka, FLBuilt 1997 · S/N 17280050N596DLCrater Lake Leasing LLC · Las Vegas, NVBuilt 1977 · S/N 18265642N596FAOcala Aviation Services Inc · Ocala, FLBuilt 2004 · S/N 172S9596N5970EKolodziejczak Benjamin D · Orchard Park, NYBuilt 1959 · S/N 17470N5970GOritz Benjamin Dale · Senoia, GABuilt 1969 · S/N 15071470N5970TOmlid Robert L · Watford City, NDBuilt 1964 · S/N 15060670N5971ABolton Warren S Jr · Niles, MIBuilt 1956 · S/N 28571N5971RBowers Joshua Shane · Ballston Lake, NYBuilt 1965 · S/N 17253640N5972AWillams Christopher R · Lingleville, TXBuilt 1956 · S/N 28572N5972ESutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 17472N5973EKcantarano LLC · Mukilteo, WABuilt 1959 · S/N 17473N5973RGrit Services LLC · Manila, ARS/N 17253642N5974EHunt Ellwood M · Texarkana, TXS/N 17474N5975ADuke Robert D · Darrouzett, TXBuilt 1956 · S/N 28575N5975EFoley Charles E · Poland, MEBuilt 1959 · S/N 17475N5975RBates Kristopher M · Zanesville, OHBuilt 1965 · S/N 17253644N5976AN5976a LLC · Marathon, FLS/N 28576N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976RMeadows Robert K · Macon, GABuilt 1965 · S/N 17253645N5976TBickel Garret E · Perry, MOBuilt 1964 · S/N 15060676N5977JTemplet Eugene P · Pearl River, LABuilt 1971 · S/N A1500277N5977RWhitney Nathan B · Falkville, ALS/N 17253646N5977TBass Daniel J · Winona, MNBuilt 1964 · S/N 15060677N5978JVigil Clyde R · Chimayo, NMS/N A1500278N5979ELamarca Kenneth M · Jonesboro, GABuilt 1959 · S/N 17479N5979GHargrave Michael K · Gladwin, MIBuilt 1969 · S/N 15071479N597DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12068N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041
Back to AD 79-10-14 R1