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.

N3951AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 4993N3953AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7004N3972AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7082N3983AUS Department Of Homeland Security · Washington, DCBuilt 2011 · S/N 7101N39EWTuckamore Aviation Corp · Hudson, MABuilt 2002 · S/N 3570N401MFDare 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 4184N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950N410CKCharm City Aviation LLC · Baltimore, MDBuilt 2004 · S/N 3793N411LHApex 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 4204N420JABristow LLC · Lake Charles, LABuilt 2007 · S/N 4212N425AMFirst-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 7017N448AEShedhorn Construction Inc · Bozeman, MTBuilt 1999 · S/N 3210N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N450CCHosking Aviation Inc · Bountiful, UTBuilt 1983 · S/N 1682N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932N456AEEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 3492N461SAAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3605N464RMRegional 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 4638N503PHCity Of Miami Police Department · Miami, FLBuilt 2015 · S/N 8089N506LFAir 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 4682N511SCSabercat Productions LLC · Scottsdale, AZBuilt 2008 · S/N 4360N522SCSouth Coast Helicopters LLC · Fullerton, CABuilt 1985 · S/N 1878N530HBas 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 4315N543MMHappyheight Inc · El Monte, CABuilt 2013 · S/N 7636N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123
Back to AD 2009-08-08 R1