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.

N94211Jskp Enterprises LLC · Dover, DEBuilt 1974 · S/N 21060542N94219Feenstra Patrick · Scottsdale, AZBuilt 1977 · S/N 18503291N9421AWillie Brett A · Decorah, IABuilt 1949 · S/N 15242N9421DJeff Air Pilot Services LLC · Shelbyville, INBuilt 1984 · S/N 172RG1154N9421EStroemsvik Kristian · Strasburg, VABuilt 1979 · S/N 17272257N9421ZL&W Leasing LLC · Smyrna, TNBuilt 1997 · S/N 17280267N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549N9422BFallbrook Air Service · Fallbrook, CAS/N 55222N9422HFort Smith Flying Club Inc · Fort Smith, ARBuilt 1981 · S/N 18267946N9422KFaulkner Harry E Jr · Bethel, AKS/N U20604395N9422TGraves Frank C · Nocona, TXBuilt 1960 · S/N 57222N9422UHortman Ryan Davis · Summerville, SCBuilt 1976 · S/N 15078370N9422XLittle Bird Airways LLC · Hamburg, NYBuilt 1962 · S/N 21057722N94237Brett Ryan J · Wasilla, AKBuilt 1977 · S/N 18503294N9423ADyer Shane E · White Hills, AZBuilt 1949 · S/N 15244N9423BDrean Alelandre C · Ajo, AZS/N 55223N9423MPaquette Ralph H Jr · Apalachin, NYBuilt 1976 · S/N 18264749N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559N9424EAero Equities LLC · Ventura, CABuilt 1979 · S/N 17272259N9424FOwens Mark T · Zionsville, INBuilt 1998 · S/N 17280390N9424TGill Melvin L Jr · Nashville, TNS/N 57224N9425AZimmerman Scott Andrew · Palmdale, CABuilt 1949 · S/N 15246N9425BGloeckler Alex · Pearl City, ILBuilt 1958 · S/N 55225N9425CInternational Air Services Inc Trustee · Carson City, NVBuilt 1955 · S/N 31823N9425HWingsleasing LLC · Wichita, KSBuilt 1975 · S/N 17266153N9425TBlue Skies Flying Services LLC · Blandon, PABuilt 1960 · S/N 57225N9425XOatney Jared C · South Hutchinson, KSBuilt 1985 · S/N 18268518N94260Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1977 · S/N 18503296N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569N94266Braun Kristy J · Fairbanks, AKBuilt 1977 · S/N 18503297N94267Hop Props LLC · Houston, TXBuilt 1974 · S/N 21060571N9426CBenson Fred B · Cle Elum, WABuilt 1955 · S/N 31824N9426EDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 17272261N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572N9426XBradley Brunhilde K Trustee · Litchfield Park, AZBuilt 1961 · S/N 21057726N9427MWillthedrill LLC · Las Vegas, NVBuilt 1976 · S/N 18264751N94285Great Lakes Enterprises · Heron, MTBuilt 1974 · S/N 21060584N9428AHoyt Richard A · Webster Groves, MOBuilt 1949 · S/N 15249N9428CJones Kathleen W · Springfield, ORBuilt 1955 · S/N 31826N9428GSecond Wind Aviation Corp · Friday Harbor, WABuilt 1970 · S/N U20601628N9429ARegistration Pending · Chicago, ILRegistration pendingBuilt 1950 · S/N 15461N9429CLanham Rex E Jr · Boise, IDBuilt 1955 · S/N 31827N9429UTangleport LLC · Amarillo, TXBuilt 1976 · S/N 15078377N9429XWorld Missions Outreach · Brownsville, TXBuilt 1985 · S/N 18268521N942AZAz2025 LLC · Miami, FLS/N 17276530N942FAPropability One LLC · Daytona Beach, FLBuilt 2003 · S/N 172S9402N942JMPogany Steve C · Chugiak, AKBuilt 1976 · S/N U20603365N942SAWalker John A · Kotzebue, AKS/N TU2060553N942SMMackie Jonathan M · Manistique, MIBuilt 1969 · S/N T210-0416N942XAClymer Jordan · Cape Canaveral, FLS/N 15070510
Back to AD 79-10-14 R1