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.

N7226V226v LLC · Zachary, LABuilt 1977 · S/N R1722302N7227ANewman Christan C · Niota, TNBuilt 1956 · S/N 29327N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527N72285Cave Creek Organics LLC · Flagstaff, AZBuilt 1969 · S/N U206-1351N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353N7228APaine Jered J · Cashmere, WAFirst renewal noticeBuilt 1956 · S/N 29328N7228GFasking Dan · Stanford, ILS/N 17258928N7228MBarton Chris · Bedford, WYBuilt 1958 · S/N 55528N7228SMendoza William S · Antioch, CABuilt 1967 · S/N 15067928N7228XBrown Richard D · Woodward, OKBuilt 1961 · S/N 15059328N72298Ronald D Mcgill Farms Inc · Klamath Falls, ORS/N 33701556N7229ASale Reported · Belleville, ILSale reported, pending cancellationBuilt 1956 · S/N 29329N7229ECreighton Richard L · Cincinnati, OHBuilt 1959 · S/N 52229N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529N7229TSmith Carl L · Vinita, OKS/N 46829N722AARobinson Charles F Jr · Portage, MIBuilt 1972 · S/N 17261274N722BASunshine Airplanes LLC · Chandler, AZBuilt 1971 · S/N 18260915N722BCNordberg Chad J · Moses Lake, WABuilt 1973 · S/N 18262051N722BSAnstrand Charles J · Boise, IDBuilt 1959 · S/N 52252N722CPFalcon 118 Denver LLC · Tiburon, CABuilt 1998 · S/N 18280090N722DMU S Wire Manufacturers Inc · Redwood City, CABuilt 1998 · S/N 18280199N722EELipham William H · Odessa, TXBuilt 1965 · S/N 18256238N722EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12824N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332N722HGAmeriflyers Of Florida LLC · Addison, TXBuilt 1998 · S/N 17280402N722JC722jc LLC · Tyler, TXBuilt 1968 · S/N 18259489N722LAllen Steven C · Crittenden, KYBuilt 1976 · S/N 15078489N722LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13199N722MAK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11324N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833N722RGTri Ag Supply Inc · Harvard, ILBuilt 1981 · S/N 18268099N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651N722SAElmendorf Afb · Elmendorf Afb, AKS/N 17280026N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361N722TMHenry John W · San Jose, CABuilt 1968 · S/N 18259512N72306Usda Aphis Ppq · Edinburg, TXBuilt 1969 · S/N U206-1360N72309Orion Works Ltd · Denali Park, AKBuilt 1969 · S/N U206-1362N7230GMaples Kevin T · Pueblo, COS/N 17258930N7230MSpring-Air LLC · De Graff, OHBuilt 1958 · S/N 55530N7230QArcade Flying Club Inc · El Dorado Hills, CABuilt 1972 · S/N 17260530N7230SMarsh John E · Washington, DCBuilt 1976 · S/N 18265084N72313Alaskan Air Charter LLC · Anchorage, AKBuilt 1969 · S/N U206-1365N7231QDsr-Cherokee 180 LLC · Dallas, TXS/N 17260531N7232ABakunova Eugenia S · Cordova, AKBuilt 1956 · S/N 29332N7232ESitta Donald C · Farmington, NMBuilt 1959 · S/N 52232N7232NT&A Farm LLC · Rifle, COBuilt 1974 · S/N 18263023N72337Gilbert Daniel Keith · Kodiak, AKBuilt 1969 · S/N U206-1374N7233MGunderson David A · Box Elder, SDBuilt 1958 · S/N 55533N7233SHeidelberg Haley · Huntington, TXBuilt 1967 · S/N 15067933
Back to AD 79-10-14 R1