OpenAirDocs.org
AD 2003-08-06

Registered aircraft · 273

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:2003-08-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-08-06')
  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.

N228LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3316N229LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3317N234BUHeli-USA Corp · Houston, TXS/N 1210N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N252CHCoastal Helicopters Inc · Juneau, AKBuilt 1996 · S/N 2954N253CHCoastal Helicopters Inc · Juneau, AKBuilt 1997 · S/N 2974N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306N275BPCity Of Burbank · Burbank, CAS/N 1930N279CHCoastal Helicopters Inc · Juneau, AKBuilt 1979 · S/N 1149N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N288WSWorld Trade Enterprises LLC · Lucas, TXBuilt 1988 · S/N 2087N28LBCity 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 7810N29HDHelinet Aviation Services LLC · Van Nuys, CABuilt 1995 · S/N 2874N29LBCity 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 4099N312BPatriot Aviation Inc · Greenville, DES/N 2243N316ELMercy Air Helicopter Inc · Fort Lauderdale, FLS/N 3660N320PANs Air Leasing LLC · Wilmington, DEBuilt 1988 · S/N 2143N323AHBristow LLC · Lake Charles, LABuilt 2008 · S/N 4649N323LAWestern Summit Enterprises Inc · Pacoima, CABuilt 2000 · S/N 3278N326PDCity Of Anaheim · Fullerton, CAS/N 4555N338SFErie County · Buffalo, NYBuilt 2001 · S/N 3480N340PMAllred Leasing LLC · Missoula, MTBuilt 2004 · S/N 3778N345HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 1357N349PAPathfinder Leasing LLC · Anchorage, AKBuilt 1995 · S/N 2868N34CMNewcomer Christopher · Navasota, TXBuilt 2002 · S/N 3528N350BAEuro Tec Vertical Flight Solutions LLC · Eudora, KSS/N 2788N350DHGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2002 · S/N 3567N350FSDiscovery Helicopters LLC · Las Vegas, NVBuilt 1993 · S/N 2728N350GYAir Services International Leasing LLC · Fort Lauderdale, FLBuilt 2003 · S/N 3747N350HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2007 · S/N 4343N350LPAirman Helicopter Inc · Fort Lauderdale, FLBuilt 1987 · S/N 2041N350MALabutte Air Inc · Flint, MIFirst renewal noticeBuilt 1986 · S/N 1882N350NTNorth Texas Helicopters Inc · Newark, TXBuilt 1982 · S/N 1512N350RAirwest Helicopters Inc · Redlands, CABuilt 2000 · S/N 9015N350RFZirkle Aviation LLC · Selah, WABuilt 2008 · S/N 4608N350RNGazelle LLC · Henderson, NVS/N 1809N350SHJc Aircraft Leasing LLC · Wasilla, AKBuilt 1998 · S/N 3073N350UKInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 1244N350XDInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 4805N351FSDiscovery Helicopters LLC · Las Vegas, NVBuilt 1997 · S/N 3038N351FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4704N351HNDiscovery Helicopters LLC · Las Vegas, NVBuilt 1996 · S/N 2957N351VSAlpine Air Alaska LLC · Girdwood, AKBuilt 2000 · S/N 3298N352PDSuffolk County Police Department · Yaphank, NYBuilt 2009 · S/N 4741
Back to AD 2003-08-06