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.

N95SKCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 1921N95TVHelicopters Inc · Wilmington, DEBuilt 2005 · S/N 52316N960GCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1998 · S/N 53237N963JSLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53680N968GWGrady White Boats Inc · Greenville, NCBuilt 2013 · S/N 54437N969RLRanger Aviation Leasing LLC · Wilmington, DES/N 3969N96AEAir Evac Ems Inc · O Fallon, MOBuilt 1982 · S/N 45751N96BHBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 51011N96GUArcher Air LLC · San Jose, CABuilt 2013 · S/N 54399N96NWNorthwest Helicopters Inc · Olympia, WABuilt 1995 · S/N 4389N970CGm Leasing Company LLC · Broussard, LABuilt 2012 · S/N 54347N970CLQwest Corp · Broomfield, COBuilt 2013 · S/N 54414N970QHeli Works Flight Services LLC · Deer Lodge, MTBuilt 1988 · S/N 51255N971RHTurbines Ltd · West Point, NEBuilt 1972 · S/N 797N972RHFriend Ships · Galveston, TXBuilt 1976 · S/N 2050N973LNMetro Aviation Inc · Shreveport, LAS/N 54821N973MFMercy Flights Inc · Medford, ORBuilt 2021 · S/N 54944N973NANational Aeronautics And Space Administration · Houston, TXS/N 3884N973RLAeronautical Services Group Inc · Palmetto Bay, FLBuilt 2009 · S/N 53973N974HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1999 · S/N 53329N974WBCk Helicopters LLC · Jasper, INBuilt 1974 · S/N 1425N975NANational Aeronautics And Space Administration · Houston, TXS/N 3887N975RHTurbines Ltd · West Point, NEBuilt 1996 · S/N 4415N975SCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54940N975TRBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 1235N976NANational Aeronautics And Space Administration · Houston, TXS/N 3889N977MSMaricopa County · Phoenix, AZBuilt 2014 · S/N 54519N979HBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 51403N979NFresh Air LLC · Camarillo, CABuilt 1983 · S/N 45777N979RHTurbines Ltd · West Point, NEBuilt 1989 · S/N 4080N97HHMgs Co Inc · Hazle Township, PAS/N 2172N97PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1979 · S/N 2632N97PXIron Horse Aviation LLC · Marshalltown, IABuilt 1984 · S/N 51114N97RRCounty Of Ocean · Barnegat, NJBuilt 1993 · S/N 4287N981RHFly Hangar 13 LLC · Mico, TXBuilt 2008 · S/N 4659N982STTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 54939N9833FKlump Aviation LLC · Bowie, AZBuilt 1992 · S/N 4205N983RHTurbines Ltd · West Point, NEBuilt 2006 · S/N 52332N985MCSt Tammany Parish Mosquito Abatement District · Slidell, LABuilt 2021 · S/N 54969N988BHeli Works Flight Services LLC · Deer Lodge, MTBuilt 2005 · S/N 52304N988LBUpshaw Roy L · Ft Worth, TXBuilt 1993 · S/N 4217N98ALAvere LLC · Twin Falls, IDBuilt 1980 · S/N 2985N98AZBig Tree Aviation LLC · Salem, ORBuilt 1977 · S/N 2296N98CLHeliinc LLC · Linden, NJS/N 52308N98CMSk Hoff Enterprises LLC · Wilsonville, ORBuilt 1989 · S/N 4056N98DJAvex Xi LLC · Fort Lauderdale, FLS/N 56428N98EAOn Target Applicators LLC · Monticello, INBuilt 1973 · S/N 935N98EGHfs Heli V LLC · New York, NYBuilt 2018 · S/N 54813N98PHOlson Gary Peter · Lanesboro, MNBuilt 1988 · S/N 51254N98SMLewis Donn C · Millington, MIS/N 658
Back to AD 2013-22-21