OpenAirDocs.org
AD 80-20-05

Registered aircraft · 204

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:80-20-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-20-05')
  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.

N109MBFirefly Aviation LLC · Midland, TXBuilt 1978 · S/N 32R-7887238N10JKZalan Aviation LLC · Cincinnati, OHBuilt 1978 · S/N 32R-7887242N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003N132CHSimon Aviation LLC · Bourg, LABuilt 1978 · S/N 32R-7887060N134CHTeke Elevate LLC · San Antonio, TXBuilt 1978 · S/N 32R-7887138N14DWBurnett Timothy S · Birmingham, ALS/N 32R-7887023N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115N177CMRapid Cloud Aviation LLC · Waxhaw, NCBuilt 1978 · S/N 32R-7887273N187GJerchau Ryan P · Bellmore, NYBuilt 1978 · S/N 32R-7887235N191RVSpurgeon Michael · Nashville, TNBuilt 1978 · S/N 32R-7887051N200MABas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887266N2078BD & P Jones Enterprises Inc · Santa Cruz, CABuilt 1979 · S/N 32R-7987022N2079XDe Flyers LLC · Vicksburg, MIBuilt 1979 · S/N 32R-7987120N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179N2087ASmith Morris A · Odessa, TXBuilt 1978 · S/N 32R-7987001N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002N21018Vega Aircraft LLC · Arcadia, OKBuilt 1978 · S/N 32R-7887186N2101FVaughan Bradley C · Truckee, CABuilt 1978 · S/N 32R-7987064N21027Noomen Excavating LLC · Currie, MNBuilt 1978 · S/N 32R-7887187N2105BNwf Aviation LLC · Defuniak Springs, FLBuilt 1979 · S/N 32R-7987025N2111ARoth David · Corrales, NMBuilt 1978 · S/N 32R-7987004N2115BMisner Gear K · Phoenix, AZBuilt 1979 · S/N 32R-7987026N2120BAec Air LLC · Springfield, MOS/N 32R-7987027N2127GKneeshaw Donald J · Gilbert, AZBuilt 1978 · S/N 32R-7987079N2129AY Naught Aviation LLC · Madill, OKBuilt 1978 · S/N 32R-7987006N2129GNorth Central Marketing Inc · Cranston, RIBuilt 1978 · S/N 32R-7987080N21313Foster Peter · University Park, TXBuilt 1978 · S/N 32R-7887200N2133ASchnack Kenneth L · Crescent, IAS/N 32R-7987007N21356Elite Financial Management Inc · Dallas, TXBuilt 1978 · S/N 32R-7887202N21357Wild Outdoors Oil LLC · Velma, OKBuilt 1978 · S/N 32R-7887203N21372Halbert Ronald S · San Diego, CABuilt 1978 · S/N 32R-7887204N2138FCima Christopher P · Plano, TXBuilt 1979 · S/N 32R-7987065N2138KGrigsby Aaron A · Victorville, CABuilt 1978 · S/N 32R-7987070N21425Nelson Phillip · Jonesboro, ARS/N 32R-7887207N21435Car Guys Aviation LLC · Lead, SDBuilt 1978 · S/N 32R-7887210N21436Smith Michael W · Bracey, VABuilt 1978 · S/N 32R-7887211N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214N2148BKaroudjian David · Savannah, GAS/N 32R-7987030N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031N2153NEagle Air US Inc · Eau Claire, WIBuilt 1979 · S/N 32R-7987096N2156EMaarouf Dan H · Taylor Village, TXBuilt 1978 · S/N 32R-7987062N2157NC A R S Sales Inc · Denver, NCBuilt 1979 · S/N 32R-7987097N2168BBonjour Hugo E · Houston, TXBuilt 1978 · S/N 32R-7987032
Back to AD 80-20-05