OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2315CRegistered aircraftBuilt 1953 · S/N 30615N2315DFeher Eugene A · Greenwich, NYBuilt 1952 · S/N 20467N2315FRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1964 · S/N 21058515N2315GClark Jeffrey E · Tiburon, CABuilt 1958 · S/N 51615N2315WAviation Partners LLC · Chesapeake, VABuilt 2007 · S/N 18281948N2315XParker Ronald Lewis · Melissa, TXBuilt 1965 · S/N 18256215N23162Dillon R Patterson Professional Services LLC · Prescott, AZBuilt 1968 · S/N 15068763N23167Walker Timothy M · Brockport, NYBuilt 1968 · S/N 15068765N2316CTwo Wings LLC · Anchorage, AKBuilt 1953 · S/N 30616N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516N2316TAircraft Solutions Group LLC · Englewood, COBuilt 1999 · S/N 17280694N2316YWhitacre James P · Martinsburg, WVBuilt 1967 · S/N 17700116N23172Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13192N23174Stewart Ellen D · Trafalgar, INBuilt 1968 · S/N 15068771N23175Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13194N23176Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13195N23177Career Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13197N2317GOrion Aviation LLC · Edmond, OKS/N 21061485N2317XSproul Wendell C · Hermon, MEBuilt 1965 · S/N 18256217N23182Costello Lisa · The Woodlands, TXBuilt 2023 · S/N 18283218N23187Pollauf James W · Northwood, OHBuilt 1968 · S/N 15068780N23188Reginald Caudill · Hi Hat, KYBuilt 1968 · S/N 15068781N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618N2318FBe Dozer LLC · Guy, ARS/N 21058518N2318GRedmond John R · Reno, NVS/N 51618N2318RJigamian Geoffrey T · Temecula, CABuilt 1964 · S/N 18255418N23193Smith Roger D · Fayetteville, NCBuilt 1968 · S/N 15068785N23197Martin Michael E · Doniphan, MOBuilt 1968 · S/N 15068787N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519N2319GSkydive Co · Fairburn, GABuilt 1958 · S/N 51619N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245N2319UGriffin Edward L · Bowling Green, KYBuilt 1962 · S/N 17249919N231EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13093N231PABone Jason T · Bulverde, TXBuilt 2000 · S/N 18280848N231SCBice Crystal Harmon · Temple, GABuilt 1974 · S/N 17264523N231SPIowa State Patrol · Des Moines, IABuilt 2011 · S/N 18282299N23203Wings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 17280696N23205Registration Pending · Orchard, IARegistration pendingBuilt 1968 · S/N 15068790N23206Schwind Bernard J · Kaunakakai, HIBuilt 1968 · S/N 15068791N2320DBeyer James C · Fayetteville, TNBuilt 1952 · S/N 20472N2320ESky Farmer LLC · Culleoka, TNS/N 17271232N2320GStocker Earnest E · Krum, TXBuilt 1959 · S/N 51620N23218Registration Pending · Utica, KYRegistration pendingBuilt 1968 · S/N 15068801N2321FMilson Charles · Sanford, NCBuilt 1964 · S/N 21058521N23221Bartosh David W · Abbott, TXBuilt 1968 · S/N 15068803N23228Johnston David W · Vero Beach, FLBuilt 1968 · S/N 15068809N2322CTwin Otter Internatinal Ltd · Las Vegas, NVBuilt 1953 · S/N 30622N2322DMacvey Troy R · Milan, INBuilt 1952 · S/N 20474N2322GBaker Harry K · Phoenix, AZBuilt 1958 · S/N 51622N2322RSink Lendon V · Lexington, NCBuilt 1964 · S/N 18255422
Back to AD 79-10-14 R1