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.

N31RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 1087 N320PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0430 N320TVBristow LLC · Lake Charles, LABuilt 2006 · S/N 0467 N321LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0465 N321RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2016 · S/N 1215 N323PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0434 N324PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0571 N324XMBristow LLC · Lake Charles, LABuilt 2011 · S/N 0991 N325DBBristow LLC · Lake Charles, LABuilt 2011 · S/N 0985 N325PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0576 N326PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0435 N327PHPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 0445 N328PHPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 0450 N329PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0489 N330PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0514 N332PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0519 N335DHMary Hitchcock Memorial Hospital · Lebanon, NHBuilt 2010 · S/N 0913 N335MLMercy Hospital Springfield · Springfield, MOBuilt 2006 · S/N 0451 N337PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0456 N340SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9411 N344PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0459 N347MTNorth Shore-Lij And Yale New Haven Health Medical · Great Neck, NYBuilt 2013 · S/N 1147 N348MHMaritime Helicopters · Homer, AKBuilt 2007 · S/N 0543 N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163 N365UCAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9246 N36RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2009 · S/N 0859 N370PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0464 N373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9099 N376PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0523 N37RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0646 N381MSAir Methods LLC · Greenwood Village, COS/N 9293 N381PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0611 N382PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0618 N383PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0622 N3842Air Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0428 N384PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0653 N385PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0670 N388PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0701 N389PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0710 N390FDReach Air Medical Services LLC · Santa Rosa, CABuilt 2005 · S/N 9078 N390PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0733 N391PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 0748 N399PHPhi Health LLC · Tempe, AZBuilt 2008 · S/N 9224 N39RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2009 · S/N 0850 N39VATriple M Leasing LLC · Shreveport, LABuilt 2010 · S/N 9384 N3PDSuffolk County Police Dept · Yaphank, NYBuilt 2006 · S/N 9094 N402CNChildren'S Hospital & Medical Center DBA · Omaha, NEBuilt 2013 · S/N 9570 N405EHMed-Trans Corp · Denton, TXBuilt 2008 · S/N 0739 N405TJAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0405 N406BCMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9863

Back to AD 2014-05-06 R2