OpenAirDocs.org
AD 80-04-04 R1

Registered aircraft · 341

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-04-04-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:80-04-04-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.

N504HAEastern Stearman Inc Trustee · Leesburg, VAS/N 5004N5098YMachacek Kenneth DBA · Midland, TXBuilt 1978 · S/N 5031N50HBDyer Randall J · Frazier Park, CAS/N 3063N50SDLouisville Aviation LLC · Louisville, KYBuilt 1965 · S/N 3458N514HEJohnson Flying Service LLC · Exira, IABuilt 1968 · S/N 7654N5162BK D Helicopters Inc · Shingleton, MIBuilt 1957 · S/N 1980N5167BStills Inc · Ashville, ALBuilt 1957 · S/N 1996N5172BJames David R · Wayne, MIBuilt 1957 · S/N 2008N5179Bishop Kurt D · Findlay, OHBuilt 2007 · S/N 623N51846Magnum Aviation LLC · Goff, KSBuilt 1978 · S/N 78-015N51850Hendrickson Flying Service Inc · Rochelle, ILBuilt 1978 · S/N 78-018N51851Brothers Aviation LLC · Black Rock, ARBuilt 1978 · S/N 78-019N51859Barr Andrew B · Beulah, MSBuilt 1979 · S/N 79-026N518HAClassic Helicopters LLC · Choteau, MTBuilt 1977 · S/N 5018N5220URitel Copter Service Inc · Hudson, IABuilt 1964 · S/N 3150N52FHVertical Aviation Technologies Inc · Sanford, FLBuilt 2002 · S/N 12N5325VBouschor William V · Curtis, WABuilt 1959 · S/N 954N5362VSale Reported · Xxx, OKSale reportedS/N 2050N5363VEvergreen Avn & Space Museum & The Capt Michael · Mcminnville, ORBuilt 1960 · S/N 2049N5374VBank Of Utah Trustee · Salt Lake City, UTBuilt 1961 · S/N 2073N53990Sibert Keith · St Maries, IDS/N 3684N53997Frederickson Don · Kokomo, INBuilt 1967 · S/N 3778N53HBJohnson Helicopter Service Inc · Kuna, IDBuilt 1966 · S/N 3257N5495EScotts Helicopter Services Inc · Le Sueur, MNBuilt 1964 · S/N 1916N549MCBulldog Air LLC · Becker, MSBuilt 2000 · S/N T20608168N555DScotts Helicopter Services Inc · Le Sueur, MNBuilt 1956 · S/N 1478N55ZDAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1969 · S/N 7689N5710Tato Hauling Services LLC · Middletown, DEBuilt 1958 · S/N 2126N58078Morten Helicopters · Larlmore, NDBuilt 1973 · S/N 25110N58115Morten Jesse L · Larimore, NDBuilt 1973 · S/N 25117N58124North-Air Helicopters Inc · Frankfort, NYBuilt 1973 · S/N 25124N58BABank Of Utah Trustee · Salt Lake City, UTBuilt 1957 · S/N 969N59402Galloway Douglas A · Sandusky, OHBuilt 1973 · S/N 25139N59403Worthy Gary L · Atwood, KSBuilt 1973 · S/N 25140N5990Aaa Aerial Solutions LLC · Dassel, MNS/N 2396N59HAircraft Sales LLC · Caledonia, MIBuilt 1951 · S/N 325N6140CNorth Coast Helicopter Service Inc · Napa, CABuilt 1948 · S/N 47N6141Black Shadow Aviation Inc · Georgetown, FLS/N 1506N6145GChamberlain Khaythan · Lodi, CABuilt 1982 · S/N 5177N6173Whirlybirds LLC · Monroe, CTS/N 2253N6203NHendrickson Flying Service Inc · Rochelle, ILBuilt 1969 · S/N 7875N62221Lundell Levi T · Bolling Afb, DCBuilt 1947 · S/N 16N62347Dechene Corp · Big Lake, MNBuilt 1961 · S/N 1247N62361Horizon Helicopters LLC · Toms River, NJBuilt 1975 · S/N 1067N62372Classic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1229N62392Crawford James B Jr · Salmon, IDBuilt 1964 · S/N 1591N62455Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1962 · S/N 1438N62458Bank Of Utah Trustee · Salt Lake City, UTBuilt 1962 · S/N 1404N6250NOver The Top Aviation Inc · Jonesboro, ARBuilt 1967 · S/N 7881N6288NWilbur-Ellis Co · Salinas, CABuilt 1968 · S/N 7888
Back to AD 80-04-04 R1