Skip to content

AD 2009-08-08 R1

Registered aircraft · 505

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-08-08-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-08-08-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-08-08-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-08-08-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-08-08-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-08-08-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.

N728AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7248 N72LCLee County Sheriffs Office · Fort Myers, FLBuilt 1992 · S/N 2628 N735SHSouthwest Geologic Survey LLC · Mesquite, NVBuilt 2012 · S/N 7315 N736AMAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7366 N744HDU S Helicopters Inc · Marshville, NCBuilt 1981 · S/N 1449 N745RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1982 · S/N 2047 N745SHKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2012 · S/N 7455 N746RHUnited Helicopter Leasing LLC · Honolulu, HIBuilt 1992 · S/N 2603 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 N775MAMercy Air Helicopter Inc · Fort Lauderdale, FLBuilt 1984 · S/N 1802 N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395 N779CPChaparral Air Group · Grapevine, TXBuilt 2001 · S/N 3452 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 N783FBFb Helicopter LLC · Banks, ORBuilt 1987 · S/N 1995 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 N801HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2013 · S/N 7788 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 N805BTBeta Fleet LLC · South Burlington, VTBuilt 2002 · S/N 3563 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 N808LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4983 N808MHAirstar Leasing LLC · Henderson, NVBuilt 2005 · S/N 3914 N80NTLos Angeles Interagency Metropolitan Police · Commerce, CABuilt 2007 · S/N 4352 N810CESouthern California Edison · Chino, CABuilt 2006 · S/N 4112

Back to AD 2009-08-08 R1