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.

N6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51439N654AMAir Methods LLC · Greenwood Village, COS/N 56484N654PFSale Reported · North Salt Lake, UTSale reportedBuilt 2016 · S/N 54679N655RAMed-Trans Corp · Denton, TXBuilt 2012 · S/N 54116N6566ABrowns 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 2295N657HAAgricultural Air Services LLC · Jupiter, FLBuilt 1993 · S/N 52044N658HPDiamondback Equipment Leasing LLC · Avondale, AZBuilt 2005 · S/N 53665N65ALHq Rentals Ltd · Dover, OHS/N 1443N65DJHornet Aviation LLC · New York, NYBuilt 2024 · S/N 56398N65RMRmc Aviation LLC · Klamath Falls, ORBuilt 2004 · S/N 52300N66013Blackbird Aero LLC · Boca Raton, FLBuilt 2002 · S/N 5283N6603XAerial Applicators Of Missouri LLC · Jonesboro, ARBuilt 1990 · S/N 51412N660AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 54108N660AMAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 56483N660HAHelicopter Applicators Inc · Gettysburg, PABuilt 1979 · S/N 45219N660RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53248N661RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53284N662CVSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N 54374N662RLRotocraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53203N663RLRotorcraft Leasing Company LLC · Broussard, LABuilt 2001 · S/N 53479N663SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53438N664RLGm Leasing Company LLC · Broussard, LABuilt 1996 · S/N 53037N6651HR & R Conner Aviation LLC · Conner, MTBuilt 1979 · S/N 45211N665HFHalo Flight Inc · Corpus Christi, TXBuilt 2025 · S/N 56442N666SLIrondequoit Acquisitions LLC · Miami, FLBuilt 2024 · S/N 56431N668RLGm Leasing Company LLC · Broussard, LABuilt 1999 · S/N 53383N669RLGm Leasing Company LLC · Broussard, LABuilt 2003 · S/N 53550N66RRRiggs Rock Alan · Lake Mary, FLBuilt 1979 · S/N 45278N67001Usda Aphis Ws Atoc · Cedar City, UTBuilt 1993 · S/N 5101N67041Desoto County Sheriff Dept · Hernando, MSBuilt 1993 · S/N 5104N67053West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5105N67099Spartanburg County Sheriffs Office · Spartanburg, SCBuilt 1993 · S/N 5108N670PCSan Diego County Sheriffs Department · San Diego, CABuilt 2023 · S/N 56345N670RLGm Leasing Company LLC · Broussard, LABuilt 2000 · S/N 53413N67110Mf Helicopters LLC · East Troy, WIBuilt 1993 · S/N 5109N67113West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5111N6712LBell Textron Inc · Fort Worth, TXS/N 54523N67130Mf Helicopters LLC · East Troy, WIBuilt 1993 · S/N 5113N67147Usda Aphis Wildlife Services · Cedar City, UTBuilt 1993 · S/N 5115N67172Veturis David · Lake Forest, CABuilt 1993 · S/N 5118N67176Kootenai County Regional Air Support · Hayden, IDBuilt 1994 · S/N 5119N67183State Of Louisiana · Baton Rouge, LABuilt 1993 · S/N 5120N671RLGm Leasing Company LLC · Broussard, LAS/N 53480N67231United States Army · Ft Rucker, ALFirst renewal noticeBuilt 1993 · S/N 5124N67234Brown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 5125N67235Brown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 5126N67265Usda Aphis Ws · Cedar City, UTBuilt 1993 · S/N 5130N67269Usda Aphis Ws · Cedar City, UTBuilt 1994 · S/N 5132
Back to AD 2013-22-21