OpenAirDocs.org
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
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.

N157AEBoeing Company · Mesa, AZBuilt 2011 · S/N 7171N15NSChopper 3 LLC · Dover, DEBuilt 1997 · S/N 3014N172AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3839N173BHBhh Leasing #4 LLC · Pensacola, FLBuilt 2009 · S/N 4614N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N209LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4960N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N212HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4703N212KPitch Link LLC · New York, NYBuilt 2010 · S/N 7030N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N217HPNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3628N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879N234BUHeli-USA Corp · Houston, TXS/N 1210N242ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7176N243GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4617N244CPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 7036N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N245AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7154N249GSPau Hana Enterprises LLC Series III · Las Vegas, NVBuilt 1988 · S/N 2167N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N253LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7158N255LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7140N255RMCgcpr LLC · Canovanas, PRBuilt 2009 · S/N 4855N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203N259AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7050N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N267AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7215N267RCBank Of Utah Trustee · Salt Lake City, UTS/N 7393N26HXNs Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 4385N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273N279AMAir Methods LLC · Greenwood Village, COS/N 4685N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N28LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3757N296PDCity Of Philadelphia · Philadelphia, PABuilt 2013 · S/N 7705N297PDCity Of Philadelphia · Philadelphia, PABuilt 2014 · S/N 7810N29LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3760N29LWTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4485N2SDPinellas County Sheriff'S Office · Clearwater, FLBuilt 2006 · S/N 4099
Back to AD 2009-08-08 R1