OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,382

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

N88TANorthwest Helicopters I Inc · Olympia, WABuilt 1980 · S/N 2990N88TCHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2220N88VRBlue Copters LLC · Saint Petersburg, FLS/N 54902N88ZAN88za LLC · New York, NYBuilt 2019 · S/N 54826N890RPAmerican Ag Aviation Inc · Five Points, CABuilt 1982 · S/N 3602N890SPWest Virginia State Police · South Charleston, WVBuilt 2001 · S/N 5269N894HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 2012 · S/N 54383N894HAHelo N894ha LLC · Richmond, VAS/N 3278N895SCAerospace Trust Management LLC Trustee · Wilmington, DES/N 1611N895SPWest Virginia State Police · South Charleston, WVBuilt 1995 · S/N 5220N896KKCg Leasing LLC · Mobile, ALBuilt 2021 · S/N 54928N897KVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 54022N897MTTextron Financial Corp · Wichita, KSBuilt 2023 · S/N 56385N899BHNisource Corporate Services Co · Gary, INFirst renewal noticeS/N 51089N89AEAir 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 4089N8BQBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 51108N8NFCity 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 695N901NMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54649N90209Wooding 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 45756N903GAMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 54459N903MHMansfield Heliflight Inc · Milton, VTS/N 53274N9047CHenderson Aviation Co · Junction City, ORBuilt 1997 · S/N 52201N904BASky One Helicopters LLC · New Haven, MOBuilt 1974 · S/N 1504N905MFMaine Department Of Conservation · Old Town, MEBuilt 2007 · S/N 53769N905WPCenterline Holdings · Camden, DEBuilt 1981 · S/N 3224N906GFAir Evac Ems Inc · O Fallon, MOBuilt 2003 · S/N 53578N907GFAtlantic Union Bank · Alpharetta, GABuilt 2021 · S/N 54950N907MDMorrow Air Vi LLC · Vero Beach, FLBuilt 2009 · S/N 53968N907RGBentley Drive LLC · Anchorage, AKBuilt 1982 · S/N 51041N908DFDesg Holdings LLC · Houston, TXBuilt 2014 · S/N 54493N908GFAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53171N909GFAir Evac Ems Inc · O Fallon, MOBuilt 2020 · S/N 54931N90CLHelicopters Inc · Wilmington, DEBuilt 1989 · S/N 4066
Back to AD 2013-22-21