OpenAirDocs.org
AD 2012-16-03

Registered aircraft · 34

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

N19FLJones Kyle M · Kerrville, TXBuilt 2006 · S/N 71-CN2QRHolder Robert W · Pittsfield, PABuilt 1999 · S/N 31N304AMWillamette Valley Soaring Club Inc · Cornelius, ORS/N 22N304AZVihlen Ryan S · Smyrna, GABuilt 1999 · S/N 14N304BLRinell Eric S · San Luis Obispo, CABuilt 2000 · S/N 17N304BSBates Matthew T · Springfield, VABuilt 2000 · S/N 27N304BUChow Timothy · Norwich, VTBuilt 2001 · S/N 41-17N304CBMurray Lee J · Appleton, WIBuilt 2004 · S/N 68-CN304CLMurphy John R · Rapid City, SDBuilt 2002 · S/N 50-17N304CZLooft Fred J · Leicester, MABuilt 1998 · S/N 3N304DDBehm Christopher B · Harbor City, CABuilt 1999 · S/N 7N304GFRusinowski Steven P · Royal Oak, MIBuilt 2000 · S/N 20N304GHZiegler Jurgen · Greenville, SCS/N 38-CN304GTDe La Torre Robert · Scottsdale, AZBuilt 2002 · S/N 62-CN304HVRizy David J · Arlington, TXBuilt 1999 · S/N 11N304JDLysy David G · Lyme, NHBuilt 2000 · S/N 30N304MTMcallister Timothy S · Miami, FLBuilt 2002 · S/N 45-CN304NMBickers Donald Sims · Knoxville, TNBuilt 2000 · S/N 24N304PMPost Mills Soaring Club Inc · Lyme, NHBuilt 2002 · S/N 47-CN304RGNevels Steven D · Merritt Island, FLS/N 39-CN304RKScott Randy W · Maple Valley, WABuilt 2002 · S/N 46-CN304RSStoyanov Nikolay S · Jersey City, NJBuilt 1999 · S/N 15N304SAHahn Peter · San Diego, CABuilt 1999 · S/N 12N304TJRegistration Pending · Raleigh, NCRegistration pendingBuilt 2002 · S/N 53-17N304TMAirtravel LLC · Reno, NVBuilt 2000 · S/N 19N304WNLynskey Stephan E · Exeter, NHBuilt 2014 · S/N 074-CN306TMCook David E · Montgomery, TXBuilt 2002 · S/N 55-CN30ATThermalator Soaring Assoc LLC · Wilmington, DES/N 54-17N342EZMcgowin Timothy P · Auburn, ALBuilt 2001 · S/N 40-17N519ECSouth George J · Mantua, OHS/N 8N551SKWallach Jari H · Buffalo, NYBuilt 2002 · S/N 51-CN712DKMcilvaine Brian A · Santa Fe, NMBuilt 2002 · S/N 59-17N839CZStrack Taylor W · West Hartford, CTBuilt 2001 · S/N 37-17N974CQStanfield Mark A · Hood River, ORBuilt 2001 · S/N 43-17
Back to AD 2012-16-03