Skip to content

AD 2014-05-06 R2

Registered aircraft · 412

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:2014-05-06-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-05-06-R2') 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:2014-05-06-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-05-06-R2')
  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:2014-05-06-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-05-06-R2')
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.

N906GLGundersen Lutheran Medical Center Inc · La Crosse, WIS/N 9089 N906SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9479 N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412 N908SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9482 N909SHSanford Health · Sioux Falls, SDBuilt 2010 · S/N 9359 N910NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9084 N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021 N911BHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9545 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 N911MKAvera Mckennan · Sioux Falls, SDBuilt 2008 · S/N 9218 N911SVSaint Vincents Healthcare · Billings, MTBuilt 2007 · S/N 0598 N911TBCook Children'S Health Enterprises · Fort Worth, TXBuilt 2009 · S/N 9281 N911TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2020 · S/N 9855 N911UWMetro Aviation Inc · Shreveport, LABuilt 2021 · S/N 9864 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 N912CCAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9595 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 N918ECPitt County Memorial Hospital Inc DBA · Greenville, NCBuilt 2007 · S/N 9121 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 N925ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9882 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 N944AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 9044 N944NHBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9181 N945MTMed-Trans Corp · Denton, TXBuilt 2021 · S/N 9871 N946MTMed-Trans Corp · Denton, TXBuilt 2021 · S/N 9872

Back to AD 2014-05-06 R2