Skip to content

AD 2013-21-05 R1

Registered aircraft · 254

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

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-21-05-R1') 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-21-05-R1') ORDER BY n_number

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-21-05-R1')
    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-21-05-R1')
  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.

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-21-05-R1')
  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-21-05-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N836CSMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1104 N836LFInhs Leasing Co LLC · Aurora, ORBuilt 2008 · S/N 0716 N837CSReach Air Medical Services LLC · Santa Rosa, CAS/N 1113 N838CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1123 N839CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1128 N840LFLife Flight Network LLC · Aurora, ORBuilt 2014 · S/N 1114 N847LFLife Flight Network LLC · Aurora, ORBuilt 2007 · S/N 0534 N865NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0584 N883AEAir Evac Ems Inc · O Fallon, MOBuilt 2008 · S/N 0749 N884AEAir Evac Ems Inc · O'Fallon, MOBuilt 2012 · S/N 1059 N885AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 1213 N885ALMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0591 N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051 N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052 N893HFHealth First Shared Services Inc · Rockledge, FLBuilt 2010 · S/N 0893 N904VUVanderbilt University Medical Center · Nashville, TNBuilt 2005 · S/N 0418 N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412 N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021 N911CKEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 0138 N911EFAir Methods LLC · Greenwood Village, COS/N 0497 N911ERAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0764 N911ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0541 N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095 N911KSMed-Trans Corp · Denton, TXBuilt 2011 · S/N 1012 N911SVSaint Vincents Healthcare · Billings, MTBuilt 2007 · S/N 0598 N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132 N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154 N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143 N911XFAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0167 N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157 N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161 N911XMAir Med Services LLC · Lafayette, LABuilt 2013 · S/N 1105 N911XUAir Med Services LLC · Lafayette, LAS/N 0713 N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164 N912BFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0344 N912EFAir Methods LLC · Greenwood Village, COS/N 0421 N913ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0562 N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018 N914THAir Methods LLC · Greenwood Village, COS/N 0440 N917ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0351 N917UTwiga Air LLC · Wilmington, DEBuilt 2007 · S/N 0550 N920AHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0699 N920NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0472 N922NHLta Group Holdings LLC · Amarillo, TXBuilt 2013 · S/N 1101 N930NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0461 N933NHLta Group Holdings LLC · Amarillo, TXBuilt 2009 · S/N 0847 N935ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0346 N935MCMetro Aviation Inc · Shreveport, LAS/N 0485 N941TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2008 · S/N 0667 N951TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2010 · S/N 0942

Back to AD 2013-21-05 R1