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.

N415AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52399N415PHPhi Health LLC · Tempe, AZBuilt 1999 · S/N 53390N416AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52403N416CFCareflite · Grand Prairie, TXBuilt 2013 · S/N 54393N416SFN390sf LLC · Chandler, AZBuilt 2002 · S/N 53538N417AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52463N417CFCareflite · Grand Prairie, TXBuilt 2013 · S/N 54409N417PHPhi Aviation LLC · Lafayette, LABuilt 1996 · S/N 53038N417PJHelibro LLC · Red Bluff, CAS/N 53493N417USCrosswind Leasing LLC · Prescott, AZBuilt 2003 · S/N 53580N4180FCaswell Farms · Durham, CABuilt 1991 · S/N 51469N418AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52405N418CFCareflite · Grand Prairie, TXBuilt 2013 · S/N 54416N418PHPhi Aviation LLC · Lafayette, LABuilt 2005 · S/N 53640N418PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 54025N418SVCanyon Creek Investments Llp · Sapulpa, OKBuilt 1978 · S/N 2399N419CFCareflite · Grand Prairie, TXBuilt 2013 · S/N 54432N419DHAerial Applicators Of Missouri LLC · Qulin, MOBuilt 1984 · S/N 51007N419PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 54133N41EWMemphis Police Department · Memphis, TNBuilt 1989 · S/N 4044N41HXHelicopter Express LLC · Chamblee, GABuilt 2008 · S/N 53866N41PHTobler Hans P · Anchorage, AKBuilt 1974 · S/N 1544N41SJMti Travel Inc · Fountain Hills, AZBuilt 1974 · S/N 1352N41TLTurbines Ltd · West Point, NES/N 53554N420AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52461N420GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2011 · S/N 54066N420PHPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 53747N420RLBlue Sky Leasing Inc · Delta, COBuilt 2004 · S/N 52303N421PHPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 53749N4227EMonarch Enterprises Inc · Kirkland, WABuilt 1981 · S/N 45702N422AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52462N422CTKing County Sheriffs Office · Seattle, WABuilt 2024 · S/N 56392N422PHPhi Aviation LLC · Lafayette, LABuilt 2005 · S/N 53675N422RHJames V Paige Jr Development Corp · Bemus Point, NYBuilt 1981 · S/N 3249N422SDParker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 1093N4237MTrideca Vertical Solutions LLC · Dallas, TXBuilt 1989 · S/N 4055N423AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52423N424AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52424N424LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56383N424MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 54124N424PHPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 53682N425PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 53684N426AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52426N426PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 53751N427MTDrillers Aviation LLC · Mt Morris, PAS/N 53620N427PPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53278N427PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 53863N427TJEagle Air Services Of North Carolina LLC · Mcdonough, GABuilt 2005 · S/N 53673N4282ZSayre Stanley · Mantua, OHBuilt 1999 · S/N 51499N428PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 53754
Back to AD 2013-22-21