Skip to content

AD 2007-19-09 R1

Registered aircraft · 313

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:2007-19-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:2007-19-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:2007-19-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:2007-19-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:2007-19-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:2007-19-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.

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 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 N794AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4440 N796AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4550 N7ZSRogue Mountain LLC · Whitefish, MTBuilt 2007 · S/N 4361 N801MHSunshine Helicopters Inc · Puunene, HIBuilt 2002 · S/N 3654 N804CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4133 N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782 N805LFAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4559 N805MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3799 N806MHAirstar Leasing LLC · Henderson, NVBuilt 2004 · S/N 3833 N806MPNs Air Leasing LLC · Wilmington, DEBuilt 2008 · S/N 4504 N806PAPathfinder Leasing LLC · Anchorage, AKBuilt 2002 · S/N 3635 N807AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4592 N807LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4928 N807MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3912 N807MLRio Bravo Helicopters Inc · Dover, DEBuilt 2008 · S/N 4411 N808CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4151

Back to AD 2007-19-09 R1