OpenAirDocs.org
AD 80-18-04 R1

Registered aircraft · 1,016

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-18-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-18-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.

N868JBHorizon Helicopter LLC · Pembroke, NHBuilt 2000 · S/N 4534N868KKCoastal Helicopters Inc · Panama City, FLBuilt 1976 · S/N 2031N86DXTopside Aviation Inc · Brasstown, NCBuilt 1986 · S/N 3960N86FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1976 · S/N 2104N86NCb Couch Inc · Walcott, ARBuilt 1980 · S/N 3204N874MAnastasia Mosquito Control District · Saint Augustine, FLBuilt 2003 · S/N 4569N885MCPolk County · Bartow, FLBuilt 2005 · S/N 4592N887EHVertical Vegetation Management LLC · Darlington, INBuilt 1975 · S/N 1774N88HCTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1975 · S/N 1576N88PPGo Heli LLC · San Diego, CABuilt 1980 · S/N 3215N88TANorthwest Helicopters I Inc · Olympia, WABuilt 1980 · S/N 2990N88TCHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2220N890RPAmerican Ag Aviation Inc · Five Points, CABuilt 1982 · S/N 3602N890SPWest Virginia State Police · South Charleston, WVBuilt 2001 · S/N 5269N894HAHelo N894ha LLC · Richmond, VAS/N 3278N895SCAerospace Trust Management LLC Trustee · Wilmington, DES/N 1611N895SPWest Virginia State Police · South Charleston, WVBuilt 1995 · S/N 5220N89AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45433N89APBlue Dasher Aviation LLC · Glastonbury, CTBuilt 1973 · S/N 975N89PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1975 · S/N 1751N89SSAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1010N89TTBrunskill Stephen D · Lodi, CABuilt 1975 · S/N 1857N8AUDodson International Parts Inc · Rantoul, KSBuilt 1990 · S/N 4089N8NFCity Of Pasadena · Pasadena, CABuilt 1978 · S/N 2537N8QDHelicopters Inc · Wilmington, DEBuilt 1991 · S/N 4189N8QVD H Helicopter Inc · Mascoutah, ILBuilt 1981 · S/N 3434N8VUOwen Aviation Services LLC · Dallas Center, IABuilt 1990 · S/N 4168N8YJHelicopters Inc · Cahokia, ILBuilt 1998 · S/N 4485N90097Johnson Aerial Spraying LLC · Brayton, IABuilt 1975 · S/N 1587N900HHHmc Lift LLC · Wilmington, DEBuilt 1980 · S/N 3139N9014QScotts Helicopter Services Inc · Le Sueur, MNBuilt 1972 · S/N 695N90209Wooding William W DBA · Anacortes, WABuilt 1975 · S/N 1724N902EHNorth Wind Aviation LLC · Chelan, WAS/N 45769N90301Corbeau LLC · Anchorage, AKBuilt 1975 · S/N 1740N90307Smith David C · Brewster, WABuilt 1975 · S/N 1747N90335Hogans Landing LLC · Bedford Hills, NYBuilt 1975 · S/N 1744N903BAMarks Lloyd L · Lafayette, LAS/N 45756N904BASky One Helicopters LLC · New Haven, MOBuilt 1974 · S/N 1504N905WPCenterline Holdings · Camden, DEBuilt 1981 · S/N 3224N90CLHelicopters Inc · Wilmington, DEBuilt 1989 · S/N 4066N90MPState Of Missouri · Jefferson City, MOBuilt 1990 · S/N 4113N90RHLarson Michael A · Perham, MNBuilt 1977 · S/N 2268N910SVGolden Age Flight Museum · Bakersfield, CABuilt 1978 · S/N 2390N911AFMarion County Sheriffs Office · Ocala, FLS/N 72-21347N911HHEwing Flying Service LLC · Morganza, LABuilt 1982 · S/N 3571N911KGCouch Helicopter Service Inc · Walcott, ARS/N 3746N911UDIndian River County Sheriff'S Office · Vero Beach, FLBuilt 1995 · S/N 5231N911UUKottman Marvin G · West Point, NEBuilt 2006 · S/N 4614N913RLAero Leasing Inc · Medford, ORS/N 2913N915RLRotorcraft Leasing Co LLC · Broussard, LAS/N 3854
Back to AD 80-18-04 R1