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.

N2831PZachman 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 972N3088PNordby Keane Arthur · Stevenson Ranch, CAS/N 977N3094PKennedy Harold L · Pflugerville, TXS/N 978N310JLLittle Air Dream LLC · Mooresville, NCBuilt 1976 · S/N 775N3122PDixon Vincent · Bellingham, WABuilt 1979 · S/N 984N3128PSilver Gary S · Farmington, UTBuilt 1979 · S/N 985N3140PRemes Stephen D · Northfield, MNBuilt 1979 · S/N 987N32DQBrooks Robert K · Beaufort, SCS/N 855N32RQI C Aviation LLC · Birmingham, ALBuilt 1975 · S/N 692N32SLLund Stephen R · Paradise Valley, AZBuilt 1976 · S/N 789N33KMathison John Michael · Fernley, NVBuilt 1977 · S/N 828N36LKAom Aircraft LLC · Wilmington, DES/N 1041N3GLSouth Louisiana Air Services Inc · Springfield, LABuilt 1979 · S/N 995N3PSAom Aircraft LLC · Wilmington, DES/N 870N41EPRegistered aircraftBuilt 1982 · S/N 1083N44FSJinsky Ronald G · Beloit, WIBuilt 1975 · S/N 717N514BMerrells Grade All Inc · Saint Cloud, FLS/N 1014N53WLW L Paris Enterprises Inc · Louisville, KYBuilt 1975 · S/N 682N5455MMacomb Air Inc · Denver, NCS/N 706N555TDSouthard Bryan O · Moneta, VABuilt 1976 · S/N 780N56LAGroat Stanley G · Austin, ARBuilt 1979 · S/N 973N6012VRegistered aircraftBuilt 1976 · S/N 767N6015VLake Loon LLC · Prairieville, LABuilt 1976 · S/N 770N6017VMangels Dale · Bremerton, WABuilt 1976 · S/N 771N6031VMason Kearney L · Hadley, NYBuilt 1976 · S/N 783N6067VAmphibians Plus LLC · Bartow, FLS/N 791N6082VStewart Glen W III · Lebanon, TNBuilt 1976 · S/N 794N6096VDavis Christopher R · Greenwood, MSBuilt 1976 · S/N 797N6107VZero Seven Victor LLC · Anchorage, AKBuilt 1976 · S/N 798N613LCPrairie Sales Inc · Eden Prairie, MNS/N 873N6150VSeaplane Adventures LLC · Cheyenne, WYBuilt 1976 · S/N 804N6151VWaldron James M · Pine River, MNBuilt 1977 · S/N 805N6154VBryan Hayes R · Anacortes, WAS/N 808N6156VJarrell Joshua E · Alexandria, VAS/N 810N6157VBabler Robert L · Grand Coulee, WAS/N 811N6158VBoli Peter K DBA Rock Leasing · Henderson, NVBuilt 1977 · S/N 812N6163VDuncan David · Colorado Springs, COS/N 816N6165VHendrix Todd · Bakersfield, CABuilt 1977 · S/N 818N6167VPayne Andrew B · Port Orange, FLBuilt 1977 · S/N 820N616RWRomeo Ouiski LLC · Winter Haven, FLBuilt 1978 · S/N 888
Back to AD 79-21-09 R1