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.

N7309SRegistration Pending · Tahoe City, CARegistration pendingBuilt 1976 · S/N 18265101N7309TRognlie Brent R · Westminster, COBuilt 1959 · S/N 46909N730AKMcmullen Michael J · Columbia, SCBuilt 1977 · S/N 18265482N730BLast Approach LLC · Fort Myers, FLS/N 18264937N730EREmbry-Riddle Aeronautical Univeristy Inc · Prescott, AZBuilt 2023 · S/N 172S13036N730HAHonaker Group LLC · Sellersburg, INS/N 17267246N730LBEarly Bird Aviation LLC · Rillito, AZBuilt 1974 · S/N 17263162N730LCJones Christopher N · Edgewood, WABuilt 1979 · S/N 18267417N730LUTextron Aviation Inc · Wichita, KSS/N 172S13599N730WMDennings Greg B · New Bremen, OHBuilt 1998 · S/N 18280361N73100Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 20700559N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010N7310QDye Development LLC · Salem, OHBuilt 1972 · S/N 18260950N7310TYowell Albert W · Etlan, VABuilt 1959 · S/N 46910N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272N73118Hudson Donald L Jr · Sellersburg, INBuilt 1975 · S/N 18264122N7311VWiliams Daniel L · Liverpool, NYBuilt 1977 · S/N R1722303N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561N7312AJohnson Thomas F · Buckeye, AZS/N 29412N7312GKlitzke Lucanus E · La Plata, NMBuilt 1973 · S/N 15074644N7312NOber John · Candor, NYS/N 18263097N7312QRegistration Pending · Wilmington, DERegistration pendingBuilt 1972 · S/N 18260952N7312SCuneo Timothy Angelo · Twin Falls, IDBuilt 1976 · S/N 18265104N7312THangar 20 Flying Club LLC · Climax, MIS/N 46912N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281N7313APerkins David A · Locust Grove, OKS/N 29413N7313GBend-Over Hill Aviation LLC · Dover, DEBuilt 1973 · S/N 15074645N7313QWoodall Dan · Raleigh, NCFirst renewal noticeBuilt 1972 · S/N 18260953N7313SRogers Matthew H · South Berwick, MEBuilt 1976 · S/N 18265105N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290N7314ASchultz David · Middleton, IDBuilt 1956 · S/N 29414N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014N7314MFrickel Daniel R · Atkinson, NEBuilt 1958 · S/N 55614N7314TCarney Mark A · Emporia, KSBuilt 1959 · S/N 46914N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293N7315ATiny Sparrow Aviation LLC · Irvine, CAS/N A1500709N7315KLittle James R Jr · Jackson, WYBuilt 1976 · S/N R1722053N7315MRolling Cole LLC · Kalispell, MTBuilt 1959 · S/N 55615N7315QNotman Steven J · Maunaloa, HIBuilt 1972 · S/N 18260955N7316ALangley Russell M · Adair, OKBuilt 1956 · S/N 29416N7316GCox Capital LLC · Rushville, MOS/N 17259016N7316MSteven Bryant · Boise, IDS/N 55616N7316NHayes Charles David · North Pole, AKBuilt 1974 · S/N 18263100
Back to AD 79-10-14 R1