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.

N5747TMontgomery Robert L · Kingman, AZBuilt 1964 · S/N 17251647N5748AGaines Matthew M · Plattsburg, MOBuilt 1956 · S/N 28348N5748CRigos George N · Whistler BcNon-citizen corporation, flight hours not reportedBuilt 1950 · S/N 19702N5748EInternational Air Services Inc Trustee · Carson City, NVS/N 17271930N5748GKozar Theodore · Connellsville, PABuilt 1969 · S/N 15071248N5748JWallner Patrick J · Redding, CABuilt 1974 · S/N 18263515N5748RStanley David W · Burleson, TXBuilt 1965 · S/N 17253417N5748TKelly Walter T · Winona, MNBuilt 1964 · S/N 17251648N5749AScobey Robert P · Weiser, IDBuilt 1956 · S/N 28349N5749GPorter John W · Center, TXBuilt 1969 · S/N 15071249N5749RMerrill Robert · Plymouth, MABuilt 1965 · S/N 17253418N5749TEast Fork Aviation LLC · Brandon, MSBuilt 1964 · S/N 17251649N574AJRippel Aviation LLC · La Salle, ILBuilt 1975 · S/N 15077148N574BWBridge State University · Bridgewater, MABuilt 2000 · S/N 17280948N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574MTGrow Michael J · Palmer, AKBuilt 1967 · S/N 185-1247N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943N574STState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606116N574WBDeal Timothy E · Anchorage, AKBuilt 1957 · S/N 34507N5750EMellen Roger B · Winston, ORBuilt 1959 · S/N 17250N5750GHolt Wayne A · Waterford, MEBuilt 1969 · S/N 15071250N5750RPeters Tricia S · Columbia City, INBuilt 1965 · S/N 17253419N5751BMacon Michael D · Sisters, ORBuilt 1956 · S/N 33751N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751JB & H Drilg · Winnsboro, LABuilt 1971 · S/N 21059451N5751RKummer Brian · Port Orange, FLBuilt 1965 · S/N 17253420N5751TGordon Robert A · North Pole, AKS/N 17251651N5752BWallace Thad Joseph · Mount Shasta, CABuilt 1956 · S/N 33752N5752CNoyes Jeffery A · Bridgeport, TXBuilt 1950 · S/N 19706N5752TStrahan Gary · Beaumont, TXBuilt 1964 · S/N 17251652N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5755ABlue Sky Flyers Inc · Joplin, MOBuilt 1956 · S/N 28355N5755EWilken Christopher W · Milford, IABuilt 1959 · S/N 17255N5755GDestination Alaska Air Service LLC · Homer, AKS/N U20603758N5755JBagge John A · Independence, IABuilt 1974 · S/N 18263520N5755REshbaugh Melvin L · Topeka, KSBuilt 1965 · S/N 17253424N5755TD2 Government Solutions LLC · New Bern, NCBuilt 1964 · S/N 17251655N5756AKunz Isaac A · Texarkana, TXBuilt 1956 · S/N 28356N5756BWages Brent · Rupert, IDBuilt 1956 · S/N 33756N5756CFly48north LLC · Lynden, WABuilt 1950 · S/N 19710N5756RCm3 LLC · North Las Vegas, NVS/N 17253425N5757BWilson Chad R · Port Angeles, WAS/N 33757N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757GWill Cutter G · San Angelo, TXBuilt 1969 · S/N 15071257N5757JAdams Gary A · Alva, OKBuilt 1971 · S/N 21059457N5757TFive Seven Tango Inc · Fitchburg, WIBuilt 1964 · S/N 17251657N5758BBentley John · Bend, ORS/N 33758N5758CFour Mound LLC · Kennewick, WABuilt 1952 · S/N 19712N5758EStrenger Thorsten · Orlando, FLS/N 17258
Back to AD 79-10-14 R1