Skip to content

AD 2009-09-03 R1

Registered aircraft · 333

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:2009-09-03-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:2009-09-03-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:2009-09-03-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:2009-09-03-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:2009-09-03-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:2009-09-03-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.

N506LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4973 N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711 N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682 N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553 N533AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4620 N538FSBayou Skys LLC · Wilmington, DEBuilt 2008 · S/N 4478 N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178 N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315 N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206 N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367 N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123 N551AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4311 N555VTArlo Air LLC · Columbus, OHBuilt 2010 · S/N 4988 N556SDHarris County Sheriffs Office · Houston, TXBuilt 2011 · S/N 7086 N55GJCfa Holdings Inc · Knoxville, TNBuilt 2003 · S/N 3745 N574AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4613 N577LFAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7362 N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736 N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733 N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876 N617GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4676 N629AMAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3941 N62ARBird Dog Aircraft LLC · Billings, MTBuilt 2006 · S/N 4175 N631SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2004 · S/N 3891 N681ASRba LLC · Kimberly, IDBuilt 2001 · S/N 3328 N694BBO307 LLC · Surprise, AZS/N 4005 N695HSMocha LLC · Tucson, AZBuilt 2016 · S/N 20047 N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749 N708PDEast Bay Regional Park District · Livermore, CABuilt 2008 · S/N 4390 N717CLR S Losee Helicopter Lc · Orem, UTBuilt 2003 · S/N 3720 N723PVN23pv LLC · Redondo Beach, CABuilt 2010 · S/N 7055 N728AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7248 N736AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7366 N751AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4455 N752AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4472 N753AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4483 N754AMUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 4650 N755AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4500 N773PAKaibab LLC · Kirkland, WABuilt 2005 · S/N 4010 N773XGooseneck Inc · Heber City, UTBuilt 2009 · S/N 4773 N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395 N779GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4630 N779PAXebec LLC · Kirkland, WABuilt 2007 · S/N 4318 N780GSAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7275 N784PAKaibab LLC · Kirkland, WABuilt 2010 · S/N 7071 N786PAXebec LLC · Kirkland, WABuilt 2002 · S/N 3498 N790AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4298 N791AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4335 N792AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4362 N793AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4413

Back to AD 2009-09-03 R1