AD 2012-18-18

Registered aircraft · 400

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-18-18')
    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-18-18')
  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.

N681ASRba LLC · Kimberly, IDBuilt 2001 · S/N 3328N694BBO307 LLC · Surprise, AZS/N 4005N695HSMocha LLC · Tucson, AZBuilt 2016 · S/N 20047N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2019 · S/N 7055N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749N708PDEast Bay Regional Park District · Livermore, CABuilt 2008 · S/N 4390N709PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760716N717CLR S Losee Helicopter Lc · Orem, UTBuilt 2003 · S/N 3720N718PPhi Aviation LLC · Lafayette, LABuilt 2007 · S/N 760686N723PVN23pv LLC · Redondo Beach, CABuilt 2010 · S/N 7055N724PHPhi 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 760692N728AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7248N72EHHelinet Aviation Services LLC · Van Nuys, CABuilt 2008 · S/N 760712N736AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7366N745PPhi Aviation LLC · Lafayette, LABuilt 2006 · S/N 760619N751AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4455N752AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4472N753AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4483N753PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760726N754AMUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 4650N754LArrow Aviation Co LLC · Broussard, LAS/N 760754N755AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4500N759MMTrevor 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 760773N773PAKaibab LLC · Kirkland, WABuilt 2005 · S/N 4010N773XGooseneck Inc · Heber City, UTBuilt 2009 · S/N 4773N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395N779GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4630N779PAXebec LLC · Kirkland, WABuilt 2007 · S/N 4318N780GSAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7275N781PPhi 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 760735N784PAKaibab LLC · Kirkland, WABuilt 2010 · S/N 7071N784RLGm 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 760639N786PAXebec LLC · Kirkland, WABuilt 2002 · S/N 3498N786RLGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 760618N787RLGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760778
Back to AD 2012-18-18