OpenAirDocs.org
AD 89-22-01 R1 L

Registered aircraft · 1,179

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:89-22-01-R1-L')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-22-01-R1-L')
  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.

N6139QRanney Steven C · Cordova, AKBuilt 1974 · S/N 1276N613LHTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1992 · S/N 51594N614N614 LLC · Ocala, FLS/N 1200N615LHIrie Leasing LLC · Trenton, NJS/N 2263N6160YGm Leasing Co LLC · Broussard, LABuilt 1992 · S/N 51609N617PBBoillat Pascal · Olympia, WABuilt 1994 · S/N 4295N6181AHiline Inc · Ball Ground, GABuilt 1993 · S/N 4277N6181KBd Aviation LLC · Sundance, WYBuilt 1993 · S/N 4276N618PCMandes George J · Homer, AKBuilt 1992 · S/N 4222N619Air Flite Inc · Shawnee, OKBuilt 1980 · S/N 45393N61CLHelicopters Inc · Wilmington, DES/N 4190N61KHKash Helicopter Services LLC · Mount Vernon, ILBuilt 1978 · S/N 2255N61NRAero Tech Helicopters LLC · Kingstree, SCBuilt 1971 · S/N 689N61PHTre Aviation Corp · Wilmington, DEBuilt 1981 · S/N 3282N620LHNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1991 · S/N 51461N622PAPatriot Aviation Inc · Greenville, DES/N 2729N623QJb Air Services LLC · Brighton, COBuilt 1988 · S/N 51258N624KRotary Flight LLC · Wilmington, DEBuilt 1974 · S/N 1540N6259CCroman Corp · White City, ORS/N 703N626United States Department Of Interior · Boise, IDBuilt 1985 · S/N 51139N629LSShook Farms LLC · Milan, MIBuilt 1984 · S/N 51077N62EHJuliett Tango LLC · Alpine, WYBuilt 1991 · S/N 4191N62FHelicopters Inc · Linden, NJBuilt 1995 · S/N 4341N62FMMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2934N63446Helicopter Services Of Illinois LLC · Fisher, ILBuilt 1981 · S/N 3439N635GTSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 906N63864Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4517N63AEAir Evac Ems Inc · O Fallon, MOS/N 45499N63SHMaine Helicopters Inc · Whitefield, MEBuilt 1979 · S/N 2640N6401XCity Of Memphis · Memphis, TNBuilt 1999 · S/N 4522N641HAHelicopter Applicators Inc · Gettysburg, PABuilt 1991 · S/N 51444N648CAChem-Air LLC · Shreveport, LABuilt 1982 · S/N 3626N64FCZma LLC · North Little Rock, ARBuilt 1981 · S/N 45539N64GKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1995 · S/N 4339N64JBNc Transportation Inc · Loudon, NHBuilt 1978 · S/N 2437N64TMLake State Companies LLC · Anchor Point, AKS/N 2513N6501SInternational Air Services Inc Trustee · Carson City, NVBuilt 1990 · S/N 51395N651HAHelicopter Applicators Inc · Gettysburg, PABuilt 1986 · S/N 51185N65231Louisville Metro Government · Louisville, KYBuilt 2001 · S/N 5281N652BBAgricultural Air Services LLC · Jupiter, FLBuilt 1984 · S/N 3800N6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51439N6566ABrowns Aviation LLC · East Hampton, CTBuilt 1973 · S/N 1204N656TLTopside Aviation Inc · Brasstown, NCBuilt 1971 · S/N 656N657CCClear Creek Construction LLC · Lysite, WYBuilt 1977 · S/N 2295N65ALHq Rentals Ltd · Dover, OHS/N 1443N66013Blackbird Aero LLC · Boca Raton, FLBuilt 2002 · S/N 5283N6603XAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 1990 · S/N 51412N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278
Back to AD 89-22-01 R1 L