OpenAirDocs.org
AD 2013-22-21

Registered aircraft · 2,381

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.

N3050SAr Aviation Group LLC · Springfield, ORBuilt 2006 · S/N 53742N305CBBerichi Aviation Helicopters LLC · Fort Lauderdale, FLBuilt 2024 · S/N 56397N305CHGeco Inc · Wilmington, DES/N 45469N305GLTickety Boo Consulting LLC · Whitefish, MTBuilt 1979 · S/N 2790N305MHMaritime Helicopters Inc · Homer, AKBuilt 2004 · S/N 52292N305PDCity Of Tucson · Tucson, AZBuilt 2005 · S/N 4586N306FWEgli Air Haul Inc · King Salmon, AKBuilt 1986 · S/N 3940N306GRBell Textron Inc · Fort Worth, TXS/N 56505N306MHOlympic Jet Inc · Olympia, WABuilt 1991 · S/N 51449N306PDCity Of Tucson Police Department · Tucson, AZBuilt 2005 · S/N 4588N306PHFinish Line Aviation LLC · Pembroke, NHS/N 45411N307KHGm Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53172N307RDHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1978 · S/N 2516N308LCLeon County Sheriffs Office · Tallahassee, FLBuilt 1995 · S/N 4367N308MHMaritime Helicopters Inc · Homer, AKBuilt 2005 · S/N 53647N308NEMed Trans Corp · Denton, TXBuilt 2022 · S/N 54992N309LWStraight Up Leasing Inc · Medford, ORBuilt 2003 · S/N 53553N309MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 53728N309RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1996 · S/N 53092N30BWAir Siete LLC · Wilmington, DEBuilt 2016 · S/N 54668N30HFN179sf LLC · Chandler, AZBuilt 2007 · S/N 53776N30VACommonwealth Of Virginia · Richmond, VABuilt 2000 · S/N 53453N31079Top Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51526N3107WWeyerhaeuser Nr Co · Seattle, WABuilt 1991 · S/N 51512N311AEAir Evac Ems Inc · O Fallon, MOS/N 45572N311DJAutonomy Aerospace LLC · Bayamon, PRS/N 53440N311FValley River Leasing Inc · Murphy, NCBuilt 1974 · S/N 1354N311MHMaritime Helicopters Inc · Homer, AKBuilt 1996 · S/N 52055N312JPTomlinson Aviation Inc · Ormond Beach, FLS/N 4580N312MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 53740N312NLYellowstone Wr Ranch LLC · Dillon, MTBuilt 1990 · S/N 51409N312STState Of Michigan · Lansing, MIBuilt 2014 · S/N 54553N313APWav Series LLC · Batavia, ILBuilt 1981 · S/N 3471N313DHRogers Helicopters Inc · Fresno, CABuilt 1981 · S/N 45630N313DPSan Diego County Sheriff Dept · El Cajon, CABuilt 2019 · S/N 54880N313HPMshr Helicopter Services LLC · Chehalis, WABuilt 1990 · S/N 51341N313MBSri Sky LLC · Madison, WIBuilt 1980 · S/N 3001N314AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 52222N314JPCity Of Jacksonville · Jacksonville, FLBuilt 2004 · S/N 53587N314MHBlade Leasing LLC · Homer, AKBuilt 1995 · S/N 52119N314SFN179sf LLC · Chandler, AZS/N 53552N315AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45482N315MHCane Helicopter Services LLC · Franklin, LABuilt 1981 · S/N 45692N315RDDc Leasing LLC · Cedar Falls, IABuilt 1979 · S/N 2852N315WCAnjum Mohammad A · Melrose Park, ILBuilt 1991 · S/N 51465N316CFLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 2264N316MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 52323N316RCHelicopter Emergency Lift Program · Pomona, NYBuilt 1974 · S/N 1268N316SPSan Juan Aviation LLC · Wilmington, DEBuilt 1983 · S/N 45768N316TVAero Products · Show Low, AZBuilt 1979 · S/N 2704
Back to AD 2013-22-21