Skip to content

AD 2014-05-06 R1

Registered aircraft · 464

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-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:2014-05-06-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:2014-05-06-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:2014-05-06-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:2014-05-06-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:2014-05-06-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.

N618GLGundersen Lutheran Medical Center Inc · La Crosse, WIBuilt 2016 · S/N 9760 N61UPTrustees Of The University Of Pennsylvania · Philadelphia, PABuilt 2012 · S/N 9556 N624ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9883 N635DHMetro Aviation Inc · Shreveport, LABuilt 2005 · S/N 0414 N635TJAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9635 N635WVanderbilt University Medical Center · Nashville, TNBuilt 2007 · S/N 0635 N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064 N641ECMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0641 N648BHFlight For Life Inc · Waukesha, WIBuilt 2021 · S/N 9869 N655DVMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1057 N655JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 1054 N665MTMed-Trans Corp · Denton, TXBuilt 2006 · S/N 0466 N676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2007 · S/N 9115 N714GEPolar Star Corp · Kalispell, MTBuilt 1966 · S/N 0060 N719LSMed Trans Corp · Denton, TXBuilt 2007 · S/N 0626 N728ABMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0683 N732HMAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0487 N738AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0738 N740MHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0740 N745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZBuilt 2009 · S/N 9295 N753MGMetro Aviation Inc · Shreveport, LAS/N 0753 N759BHAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 9397 N766MEAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 9066 N770WSMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9607 N779LFAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9103 N78NCAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 9185 N800HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2013 · S/N 1119 N806LFInhs Leasing Co LLC · Aurora, ORBuilt 2013 · S/N 1133 N810WFMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 1093 N811LVAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0573 N811MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2015 · S/N 1201 N812LVAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0614 N814LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0628 N814LVAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9137 N816ECPitt County Memorial Hospital · Greenville, NCBuilt 2015 · S/N 9685 N816LFInhs Leasing Co LLC · Aurora, ORBuilt 2009 · S/N 0793 N817LRLanai Helicopter Corp · Honolulu, HIS/N 1108 N817LVAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0651 N818MTMed-Trans Corp · Denton, TXBuilt 2011 · S/N 0989 N819LFAir Methods LLC · Greenwood Village, COS/N 0781 N823JMMassachusetts State Police · Plymouth, MABuilt 2014 · S/N 1166 N824AHMassachusetts State Police · Plymouth, MABuilt 2011 · S/N 1020 N824EHMetro Aviation Inc · Shreveport, LABuilt 2024 · S/N 9884 N825MMMassachusetts State Police · Plymouth, MABuilt 2013 · S/N 1109 N826LFInhs Leasing Co LLC · Aurora, ORBuilt 2008 · S/N 0718 N828MTMed-Trans Corp · Denton, TXBuilt 2007 · S/N 0632 N830MTMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0732 N831LFInhs Leasing Co LLC · Aurora, ORBuilt 1998 · S/N 0073 N831MEAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0493 N832CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 1050

Back to AD 2014-05-06 R1