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.

N7861SBrown Helicopter Inc · Pensacola, FLBuilt 1967 · S/N 7865N7878Hendrickson Flg Svc Inc · Rochelle, ILBuilt 1962 · S/N 2707N7885SWilbur-Ellis Co · Salinas, CABuilt 1967 · S/N 7873N7887BLidija LLC · Grass Valley, CABuilt 1958 · S/N 2023N7888BMorten David J · Larimore, NDBuilt 1958 · S/N 2024N7893BDykstra Donald J · Dorr, MIBuilt 1958 · S/N 2029N7925JChurchill Scott · Le Sueur, MNBuilt 1971 · S/N 25041N797WSWild Goose Of Plant City LLC · Thonotosassa, FLS/N 7509N7NBMagnum Aviation LLC · Goff, KSBuilt 1970 · S/N 7732N804JFTriple S Aviation LLC · Wilmington, DEBuilt 1963 · S/N 2816N8051EPatterson Casey Paul · Kinston, ALS/N TWH-15N80SQWatkins Arlo S · Chandler, AZBuilt 1959 · S/N 2522N8103JTriple F Flying Inc · Benton, PABuilt 1970 · S/N 25001N8117Henry Mark A · Dickinson, TXBuilt 1967 · S/N K732N8125JGreen Rick · Hudson, IABuilt 1970 · S/N 25004N8135JWilbur-Ellis Co · Salinas, CABuilt 1972 · S/N 25060N8140JGreen Rick A · Hudson, IABuilt 1970 · S/N 25008N81579Reddout Richard L · Tupelo, MSS/N 32R-8213037N8305WEllefson Aircraft LLC · Tyler, MNBuilt 1980 · S/N 32-8124002N8306EBreidenbach Any · Onalaska, WIBuilt 1980 · S/N 32R-8129014N8403EChurchill Scott W · Le Sueur, MNBuilt 1960 · S/N 2257N8413DExperimental Aircraft Association Inc · Oshkosh, WIS/N 25091N8424EWheatley Lester E Jr · Priest River, IDS/N 1802N8440ELand Air Enterprises · Boynton Beach, FLBuilt 1960 · S/N 2657N8441EShore Stephen A · Elkin, NCBuilt 1960 · S/N 2609N8452EMagnum Aviation LLC · Goff, KSBuilt 1962 · S/N 2752N8468EScotts Helicopter Services Inc · Le Sueur, MNS/N 2647N8478DWood Denton A · Friendswood, TXBuilt 1957 · S/N 1697N8478HBertiling Brad · North Shore, CABuilt 1958 · S/N 2214N8478LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1963 · S/N 3339N8478TLand Sea Air Leasing Corp · Ward Cove, AKBuilt 1971 · S/N 7754N8483EOwens Jeffrey H · Danville, ILBuilt 1961 · S/N 2650N8484EOver The Top Aviation Inc · Jonesboro, ARBuilt 1961 · S/N 2677N8489EQuatacker Mike · Porterville, CABuilt 1961 · S/N 1846N8492EBrooke Ash Inc · Waxahachie, TXBuilt 1961 · S/N 2714N8520HVegas Baby! Lc · Royal Oak, MIBuilt 1980 · S/N OLYMPIC-01N8522FHhi Farms LLC · Hamilton, MIBuilt 1971 · S/N 7800N8542DScotts Helicopter Services Inc · Le Sueur, MNBuilt 1966 · S/N 3546N8552FBhh Leasing #4 LLC · Pensacola, FLS/N 3705N8562FWilbur-Ellis Co · Salinas, CABuilt 1966 · S/N 7806N8593FTriple F Flying Inc · Benton, PABuilt 1966 · S/N 7820N866ZPlane Crazy Aviation LLC · Hickory, NCBuilt 1962 · S/N C-5006N86SDYoung Randall K · Clearwater Beach, FLBuilt 1973 · S/N 25118N875WEEastern Stearman Inc Trustee · Leesburg, VAS/N 5183N88755Old Time Ag Aviation LLC · Bakersfield, CAS/N 2252N88782Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1965 · S/N 1734N88ARLumley William B · Delray Beach, FLBuilt 1957 · S/N 2046N893FWFort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1979 · S/N 5085N9005TScotts Helicopter Service Inc · Le Sueur, MNBuilt 1974 · S/N CCI-74-1N9012TScotts Helicopter Services Inc · Le Sueur, MNS/N CCI-74-4
Back to AD 80-04-04 R1