OpenAirDocs.org
AD 79-21-09 R1

Registered aircraft · 154

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-21-09-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-21-09-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.

N1085LNortheast Cub LLC · Hudson, NYS/N 678N1093LKoelbl Aviation LLC · Whitesboro, TXBuilt 1975 · S/N 686N1102LRandol Dale Gibson · Lake Barrington, ILBuilt 1975 · S/N 693N1114LTriple One Four Lima Express LLC · Groton, CTBuilt 1975 · S/N 702N1122LMake A Splash Aviation LLC · Brodheadsville, PAS/N 704N119CTMccarthy John Francis · Burlington, WIS/N 732N1202LDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 707N1203LHolt Arlin J · Waterford, MEBuilt 1975 · S/N 708N1204LDiehl Matthew J · Kingston, WAS/N 709N1209LHarrist Robert K · Fort Worth, TXBuilt 1975 · S/N 714N1216LLynch Steven J · Harrisville, RIBuilt 1975 · S/N 719N1220LScott Roger W · Ooltewah, TNBuilt 1975 · S/N 723N1226LTexas Amphibians LLC · New Braunfels, TXS/N 727N1227LSmith Brant C · Anchorage, AKBuilt 1976 · S/N 728N1231LLake Amphibian Of Norwood · Norwood, MABuilt 1976 · S/N 731N1236L2sea2it · Ossining, NYS/N 735N1243LIannone Andrew Joseph · Grapevine, TXBuilt 1976 · S/N 742N1248LStearns Edwin B Jr · Eloy, AZBuilt 1976 · S/N 747N1253LTuttle David L · New York, NYBuilt 1976 · S/N 751N1254LAdventure Air Inc · Sebring, FLS/N 752N1259LLakeflyers LLC · Milford, CTBuilt 1976 · S/N 757N125LBSkyking Aviation Services LLC · Carson City, NVBuilt 1972 · S/N 521N12HCBirdwin LLC · Buras, LABuilt 1978 · S/N 909N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N151BBBlack William M · Rochester, NYBuilt 1978 · S/N 881N155JKDa Fuq Dat Beepin Be LLC · Saint Petersburg, FLBuilt 1977 · S/N 853N16DTDocktails Aviation LLC · Orlando, FLS/N 1056N16RAWesley Robert J · Chuckey, TNBuilt 1978 · S/N 944N17STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1978 · S/N 934N1HTAllen Adrian Jefrey · Sturgeon Bay, WIBuilt 1984 · S/N 1104N1QWLake 4 LLC · Charlottesville, VABuilt 1980 · S/N 1017N1VJCascadia Air Ventures Inc · Winlock, WABuilt 1977 · S/N 824N2118Carter Scott S · Orondo, WABuilt 1975 · S/N 691N21REBerts Manufacturing And Sales Inc · Sandpoint, IDBuilt 1978 · S/N 900N2504PSabovich Ronald · Lake Havasu City, AZBuilt 1977 · S/N 863N2528PSkypros East Kansas City · Grain Valley, MOS/N 865N2536POxford Aviation LLC · Altamonte Springs, FLS/N 867N2594PBlack Cat Aviation LLC · Indianapolis, INS/N 878N2596PCarlson Eric S · Kodiak, AKBuilt 1978 · S/N 879N2611PRegistered aircraftBuilt 1978 · S/N 880N2672PBland Gregory Allen · Florence, KYBuilt 1978 · S/N 884N2674PTrampe Kenneth L · Slocomb, ALS/N 886N2677PVillarreal Benigno · Mcallen, TXBuilt 1978 · S/N 887N2680PMach One LLC · Spearfish, SDBuilt 1978 · S/N 889N2682PEngeman Charles · Charlotte, NCBuilt 1978 · S/N 890N2683PJilek Dominic A · River Falls, WIS/N 891N2690PAmphibians Plus LLC · Bartow, FLBuilt 1978 · S/N 895N2691PBreton Leo · Washington, DCBuilt 1978 · S/N 896N2697PAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 899N2793PSnyder Paul Stanley · Faribault, MNBuilt 1978 · S/N 916
Back to AD 79-21-09 R1