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.

N600MTAtlantic Union Bank · Alpharetta, GABuilt 2022 · S/N 56315N601CCAir Gov II LLC · Rome, NYS/N 4565N601GMNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1981 · S/N 45638N601SJAg Air Inc · Longmont, COBuilt 1985 · S/N 51128N602SDJefferson County Sheriff'S Office · Beaumont, TXBuilt 2007 · S/N 53775N603BSNhb603 LLC · Manchester, NHBuilt 2021 · S/N 54961N6040YBell Textron Inc · Fort Worth, TXBuilt 1999 · S/N 53371N605PDNassau County Police Dept · Bethpage, NYBuilt 2007 · S/N 53787N606AHTextron Financial Corp · Wichita, KSBuilt 2022 · S/N 56329N606LBKato Aviation LLC · Henderson, MNBuilt 1978 · S/N 2448N606MTTextron Financial Corp · Wichita, KSS/N 56339N606WRW&L LLC · Dorton, KYBuilt 1997 · S/N 53201N608RANorth Wind Aviation LLC · Chelan, WABuilt 1978 · S/N 2511N60GRStemilt Growers LLC · Wenatchee, WABuilt 2003 · S/N 4570N60PHTop Gun Aviation LLC · Wendell, IDBuilt 1969 · S/N 304N60PJAero Products Component Services Inc · Show Low, AZBuilt 1978 · S/N 2349N60TLIndustrial Helicopters LLC · Scott, LABuilt 1994 · S/N 52112N60VGFarwest Aviation LLC · Billings, MTBuilt 1991 · S/N 51494N610DATimcoaviation LLC · Purvis, MSBuilt 1981 · S/N 3447N610TPCity Of Tampa Police Dept · Tampa, FLBuilt 2008 · S/N 52374N611ACStraight Up Leasing Inc · Medford, ORBuilt 2011 · S/N 54086N611PAGm Leasing Co LLC · Broussard, LABuilt 2003 · S/N 53573N612BRBrown Helicopter Inc · Pensacola, FLBuilt 1975 · S/N 1725N612KGEdb Air Inc · Wilsonville, ORS/N 2654N6133CRedlands Heli Flight LLC · Redlands, CABuilt 1991 · S/N 51544N6139QRanney Steven C · Cordova, AKBuilt 1974 · S/N 1276N613LHTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1992 · S/N 51594N613PAGm Leasing Co LLC · Broussard, LABuilt 2004 · S/N 53627N614N614 LLC · Ocala, FLS/N 1200N615LHIrie Leasing LLC · Trenton, NJS/N 2263N6160YGm Leasing Co LLC · Broussard, LABuilt 1992 · S/N 51609N616DEWestern Area Power Administration · Lakewood, COBuilt 2022 · S/N 54995N616PAGm Leasing Co LLC · Broussard, LABuilt 2006 · S/N 53723N617ACAspen Helicopters Inc · Oxnard, CABuilt 2003 · S/N 53570N617CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 54967N617DEUS Department Of Energy · Lakewood, COBuilt 2008 · S/N 53867N617PBBoillat Pascal · Olympia, WABuilt 1994 · S/N 4295N6181AHiline Inc · Ball Ground, GABuilt 1993 · S/N 4277N6181KBd Aviation LLC · Sundance, WYBuilt 1993 · S/N 4276N618DEU S Department Of Energy · Lakewood, COBuilt 2007 · S/N 53798N618DSVolusia Sheriffs Office · Deland, FLBuilt 2024 · S/N 56386N618PCMandes George J · Homer, AKBuilt 1992 · S/N 4222N618TSManatee County Mosquito Control District · Ellenton, FLBuilt 2004 · S/N 53618N619Air Flite Inc · Shawnee, OKBuilt 1980 · S/N 45393N619DEUnited States Department Of Energy · Lakewood, COBuilt 2000 · S/N 53410N61CLHelicopters Inc · Wilmington, DES/N 4190N61GRGalt Ranch Aviation LLC · Wht Sphr Spgs, MTBuilt 2008 · S/N 52378N61KHKash 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 3282
Back to AD 2013-22-21