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

N359PANs Air Leasing LLC · Wilmington, DEBuilt 2000 · S/N 3329N370NCState Of North Carolina · Raleigh, NCBuilt 2008 · S/N 4379N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239N382AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 7029N3831Air Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3947N383AKAlpha Aviation LLC · Anchorage, AKBuilt 2002 · S/N 3530N385AKAlpha Aviation LLC · Anchorage, AKBuilt 1998 · S/N 3128N387AK387ak LLC · Anchorage, AKS/N 3730N388AMFirst-Citizens Bank & Trust Co · Morristown, NJBuilt 2011 · S/N 7257N390AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7174N391LGAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4323N3931ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4697N3933ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4669N3934ADepartment Of Homeland Security · Washington, DCS/N 4713N3935ADepartment Of Homeland Security · Washington, DCS/N 4768N3937ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4796N3938ADepartment Of Homeland Security · Washington, DCS/N 4804N3939ADept Of Homeland Security Customs & Border · Washington, DCBuilt 2009 · S/N 4806N3940ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4815N3944ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4818N3946ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4706N3947ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4905N3949ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4952N3951AUS 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 4184N411LHApex 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 4204N425AMFirst-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 7017N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932N456AEEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 3492N464RMRegional 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 4638
Back to AD 2009-09-03 R1