AD 2012-12-20

Registered aircraft · 99

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

N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2019 · S/N 7055N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749N709PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760716N718PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760686N724PHPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760688N725LLMilton S Hershey Medical Center · Hershey, PABuilt 2013 · S/N 6983N725PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760692N72EHHelinet Aviation Services LLC · Van Nuys, CABuilt 2008 · S/N 760712N745PPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 760619N753PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760726N754LArrow Aviation Co LLC · Broussard, LAS/N 760754N759MMTrevor Corp DBA · Grayslake, ILBuilt 2007 · S/N 6777N759PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760690N764AMNorth Flight Aero Med · Grand Rapids, MIBuilt 2009 · S/N 760764N768AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2009 · S/N 760710N769PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760671N76HHHallecopter LLC · Wilmington, DEBuilt 2010 · S/N 760807N76ZAN76za LLC · New York, NYBuilt 2007 · S/N 760653N772PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760730N773BGBristow LLC · Lake Charles, LABuilt 2009 · S/N 760773N781PPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2006 · S/N 760630N781RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760673N782RLGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 760666N783RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760735N784RLGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 760721N785PSale Reported · Robert, LASale reported, canceledBuilt 2006 · S/N 760635N785RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760639N786RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760618N787RLGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760778N794PPhi Aviation LLC · Lafayette, LABuilt 2008 · S/N 760737N797PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760742N798PPhi Health LLC · Tempe, AZBuilt 2007 · S/N 760685N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782N821SSFly Safe LLC · Wilmington, DEBuilt 2006 · S/N 760620N849PBArrow Aviation Co LLC · Broussard, LAS/N 760652N883ALBristow US LLC · New Iberia, LABuilt 2007 · S/N 760677N891BGGm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 760679N893BGBristow U S LLC · New Iberia, LABuilt 2009 · S/N 760804N896BGBristow U.S. LLC · New Iberia, LAS/N 760777N905RDBristow LLC · Lake Charles, LABuilt 2006 · S/N 760610N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807N916LLMilton S Hershey Medical Center · Hershey, PABuilt 2011 · S/N 6885N919CMPhi Aviation LLC · Tempe, AZBuilt 2005 · S/N 760607N919SFAir Er LLC · Corinth, TXBuilt 1991 · S/N 760370N921LLMilton S Hershey Medical Center · Hershey, PABuilt 2015 · S/N 7002N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N979CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 20161N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461
Back to AD 2012-12-20