OpenAirDocs.org
AD 79-06-01

Registered aircraft · 139

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-06-01')
    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-06-01')
  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 678N119CTMccarthy John Francis · Burlington, WIS/N 732N1209LHarrist Robert K · Fort Worth, TXBuilt 1975 · S/N 714N1220LScott 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 900N2594PBlack 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 916N2831PZachman Joel J · Clear Lake, MNBuilt 1978 · S/N 922N2862PTexas Amphibians LLC · Braunfels, TXBuilt 1978 · S/N 929N2867PGaugler Andrew J · Greenwood Lake, NYBuilt 1978 · S/N 933N2878PAmphibian Enterprises Inc · Tampa, FLS/N 935N2938PLakebuccaneer Inc · Wilmington, DEBuilt 1978 · S/N 945N2939PEcg Lake Flyers Inc · Fayetteville, GAS/N 946N2969PAlaska Bush LLC · Flagstaff, AZBuilt 1979 · S/N 949N2990PDolan John C · Sequim, WABuilt 1979 · S/N 955N3002PWilson John E Jr · Tavares, FLS/N 959N3060PTadco Equipment · Laveen, AZS/N 971N3062PStay Laurence · Port Townsend, WABuilt 1979 · S/N 972
Back to AD 79-06-01