OpenAirDocs.org
AD 2004-08-12

Registered aircraft · 64

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

N100KMSorenson Daniel K · Tucson, AZBuilt 1998 · S/N 11N102HSRegistration Pending · Castle Rock, CORegistration pendingBuilt 1995 · S/N 16N103JDenman David H · Gainesville, FLBuilt 2001 · S/N 115N106DEIcarus 5280 Soaring LLC · Fort Worth, TXBuilt 2002 · S/N 131N114TWSaunders Christopher D · Lehighton, PABuilt 2000 · S/N 57N11WXPinney Charles W · Tucson, AZBuilt 2004 · S/N 159N123HHMclaughlin Patrick Lee · Redmond, ORBuilt 2005 · S/N 168N127DGBrooks Todd P · White Lake, MIBuilt 2007 · S/N 170N129PGDonnelly Mark S · Goodyear, AZBuilt 2005 · S/N 167N130CWWard Allen M · Andalusia, ALBuilt 2002 · S/N 130N140BHRegistered aircraftBuilt 2000 · S/N 85N144JSullivan Brent · Houston, TXBuilt 2000 · S/N 73N157KShelton Steven D · Washington, DCBuilt 1998 · S/N 15N15VHLehmann Lawrence W E · Pittsburgh, PABuilt 2002 · S/N 129N163AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 188N164AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 189N165AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 187N16MAKeil Carl · Granbury, TXS/N 104N200DXOpitz Michael R · Freehold, NYBuilt 1999 · S/N 50N200XMarcus Hook Glider Works · Wilmington, DEBuilt 1999 · S/N 51N204JGGreer John M Jr · Mercer Island, WABuilt 2000 · S/N 76N208UVaughn Michael E · Johns Creek, GABuilt 2002 · S/N 127N212VBFurdal Lukasz · Hillsborough, NJBuilt 2000 · S/N 75N223GCKobiesa Jacek · Pasco, WABuilt 1999 · S/N 53N257SBDuncan Marvin H Jr · Marblehead, MABuilt 2002 · S/N 145N272BLFrechtling Andrew C · Waxahachie, TXBuilt 2001 · S/N 119N28WGGeiger William D · Pittsburgh, PABuilt 2006 · S/N 220N29PSWalling Reigh A · Clifton Park, NYS/N 137N328TWAlspaugh George J · Pfafftown, NCBuilt 2007 · S/N 228N34GJHarbold Michael E · Washington, DCBuilt 2005 · S/N 165N41REEckel Robert W · Centerville, UTBuilt 1998 · S/N 10N449TZRussell Jeffrey R · Chicago, ILS/N 111N460GHGoulding Haven H Jr · Howard, PABuilt 2001 · S/N 121N47EHHalimi Emil · Bell, CABuilt 2000 · S/N 105N483AHAnderson Herman S · Flowery Branch, GABuilt 2002 · S/N 132N51CRJaeger Dieter · Decatur, GABuilt 2003 · S/N 165N523RRGlenn Tom · Fallbrook, CABuilt 2009 · S/N 232N52BXReinecke Eugene · Park City, UTS/N 171N547CMArnold Sarah D · Benton, TNBuilt 2002 · S/N 125N57LKSky Sailing Inc · Warner Springs, CABuilt 2002 · S/N 137N58HRNorris James M · Santa Barbara, CABuilt 1998 · S/N 71N597MDMaughmer Mark D · University Park, PABuilt 2004 · S/N 162N61XCStewart James R · Westford, MABuilt 1996 · S/N 31N63HRWisniewski Steven Jay Jr · Marietta, GABuilt 2017 · S/N 257N64PGGaisford Phillip A · Billerica, MABuilt 2002 · S/N 134N654DBMcintire Louis V Jr · Pecos, TXBuilt 1999 · S/N 94N67AEWeiss Donald E II · Murray, UTBuilt 1997 · S/N 60N67CRStanley Ronald L · Ellsworth, ILBuilt 2002 · S/N 144N67TTL/D Max Sales LLC · Missoula, MTBuilt 1998 · S/N 74N71EMGrandstaff Sylvia C · Tehachapi, CABuilt 1998 · S/N 6
Back to AD 2004-08-12