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.

N4952GHighland Rim Aviation LLC · Springfield, TNS/N 17273499N4953AOlson Andrew P · Garfield, WABuilt 1956 · S/N 32350N4953EInland Fisheries And Wildlife · Augusta, MEBuilt 1979 · S/N 18503919N4953GMcfly LLC · Casper, WYBuilt 1979 · S/N 17273500N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423N4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeBuilt 1958 · S/N 51054N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410N4956NCosta Luiz A · Fort Myers, FLBuilt 1980 · S/N 18267480N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425N4957DCummings Roy E · Fort Scott, KSBuilt 1958 · S/N 51057N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657N4957NRegistered aircraftS/N 18267481N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4958DHarmon Jon E · Turner, MTBuilt 1958 · S/N 51058N4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692TN4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N4959DEdwards Stephen L Trustee · Wasilla, AKBuilt 1959 · S/N 50511N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428N495EMAround The Patch LLC · Memphis, TNBuilt 1974 · S/N 18263485N495EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12270N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549N495MCC182t LLC · Chattanooga, TNBuilt 2007 · S/N 18281895N495RAGabbard Derek L · Paint Lick, KYS/N 15067052N495SPFlying Start Aero Services LLC · Reno, NVBuilt 1998 · S/N 172S8036N495WWNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282170N495ZZach Brian D · Loveland, COBuilt 1975 · S/N 15076595N4960DRasmussen Scott M · Santa Cruz, CABuilt 1958 · S/N 51060N4960RUnited States Air Force Owner · Cannon Afb, NMBuilt 1967 · S/N 17256296N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660N4961AGunson Robert S · Star, IDBuilt 1956 · S/N 32358N4961ELafferty David W · Harrisburg, ORBuilt 1979 · S/N 18503922N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508N4962DMcdonald Richard Reid · Rock Island, WAS/N 51062N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662N4962GVersteeg Martin · San Antonio, TXBuilt 1979 · S/N 17273509N4962VAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N 172RG0430N4963GSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 17273510N4963NHarrison Earl S · Clarksville, TNBuilt 1979 · S/N 18267485N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663N4964AThree Sisters Capital LLC · Visalia, CABuilt 1956 · S/N 32361N4964DGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51064N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511N4965NDowner Michael · Scottsdale, AZBuilt 1979 · S/N 18267487N4966E4966e LLC · Kalispell, MTBuilt 1956 · S/N 33000N4966GSonger Charles W III · Tuscaloosa, ALBuilt 1979 · S/N 17273513
Back to AD 79-10-14 R1