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.

N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024N401RMRegional Air Medical Services Inc. · Jasper, ALBuilt 2004 · S/N 3837N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184N40WHGm Leasing Co LLC · Broussard, LABuilt 2009 · S/N 760756N411LHApex Aeronautical · San Antonio, TXBuilt 2009 · S/N 4667N411MBVertical Corp · Kalispell, MTBuilt 2000 · S/N 3309N418TYAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4180N4204Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4204N425AMFirst-Citizens Bank & Trust Co · Morristown, NJBuilt 2011 · S/N 7264N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282N440RMRegional Air Medical Services Inc · Jasper, ALBuilt 2010 · S/N 7017N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N4514RArrow Aviation Company LLC · Broussard, LAS/N 760669N454WHGm Leasing Company LLC · Broussard, LABuilt 2010 · S/N 760802N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932N456AEEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 3492N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962N47WHInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 3653N484FAFreedom Aviation LLC · Helena, MTBuilt 2008 · S/N 4499N490HAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4539N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687N4PAPylon Aviation Services LLC · Chandler, AZBuilt 2005 · S/N 3920N500KVPortland General Electric Co · Portland, ORBuilt 2008 · S/N 4638N506LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4973N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553N533AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4620N538FSBayou Skys LLC · Wilmington, DEBuilt 2008 · S/N 4478N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123N547WMBristow LLC · Lake Charles, LABuilt 2008 · S/N 760722N551AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4311N555VTArlo Air LLC · Columbus, OHBuilt 2010 · S/N 4988N556SDHarris County Sheriffs Office · Houston, TXBuilt 2011 · S/N 7086N55GJCfa Holdings Inc · Knoxville, TNBuilt 2003 · S/N 3745N574AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4613N577LFAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7362N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876N614JCKnight Helo LLC · Wilmington, DES/N 760694N617GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4676N629AMAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3941N62ARBird Dog Aircraft LLC · Billings, MTBuilt 2006 · S/N 4175N631SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2004 · S/N 3891
Back to AD 2012-18-18