Skip to content

AD 2015-12-09 R1

Registered aircraft · 413

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:2015-12-09-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:2015-12-09-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:2015-12-09-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:2015-12-09-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:2015-12-09-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:2015-12-09-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.

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 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 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 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 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 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 N745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZBuilt 2009 · S/N 9295

Back to AD 2015-12-09 R1