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.

N491HCBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9878 N492AEAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0278 N492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9805 N504LHAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0382 N507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 9507 N509CHChildrens Hospital Colorado · Aurora, COBuilt 2023 · S/N 9881 N511UWAir Med Services LLC · Lafayette, LABuilt 2006 · S/N 0511 N512WFMetro Aviation Inc · Shreveport, LABuilt 2010 · S/N 0946 N517MTMed-Trans Corp · Denton, TXS/N 0666 N522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 9522 N523ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2022 · S/N 9876 N523MTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0821 N524MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1039 N524WFCarolinas Healthcare System DBA · Charlotte, NCBuilt 2009 · S/N 0830 N527BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0697 N529MDFlight For Life Inc · Waukesha, WIBuilt 2021 · S/N 9870 N530LNAir Methods LLC · Greenwood Village, COS/N 0471 N531LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0474 N533LCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0555 N534LNAir Methods LLC · Greenwood Village, COS/N 0453 N535DETentacle Corp · Walnut Creek, CABuilt 2013 · S/N 1100 N535LLMercy Hospital Springfield · Springfield, MOBuilt 2009 · S/N 0817 N535LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0365 N542AEAirbus Helicopters Inc · Grand Prairie, TXBuilt 2013 · S/N 9608 N545DUMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9832 N545KFAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9640 N551HUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0490 N552TJAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0552 N555YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0561 N556MTMed Trans Corp · Denton, TXBuilt 2017 · S/N 1253 N558MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1073 N55UVRector And Visitors Of The Uva Obo Medical Ctr · Charlottesville, VAS/N 9875 N575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2007 · S/N 9114 N578AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9578 N579AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0578 N585CHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9588 N586AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0709 N586WHMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 1096 N587MHAir Methods LLC · Greenwood Village, COS/N 9174 N592ACMetro Aviation Inc · Shreveport, LABuilt 2016 · S/N 9739 N599LBAir Med Services LLC · Lafayette, LAS/N 1062 N599MSAir Med Services LLC · Lafayette, LAS/N 0684 N601MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1040 N602MMTrustees Of The University Of Pennsylvania · Philadelphia, PABuilt 2009 · S/N 9241 N602MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1063 N608UWMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9850 N608WGsh Crows Nest LLC · Boston, MABuilt 2007 · S/N 0575 N611SJAspirus Wausau Hospital Inc DBA · Wausau, WIBuilt 2009 · S/N 9303 N615BDDeckoff Stephen H · St Thomas, VIBuilt 2015 · S/N 1193 N615LFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0362

Back to AD 2014-05-06 R1