OpenAirDocs.org
AD 2006-08-13

Registered aircraft · 124

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

N721NBOneonta Trading Corp · Wenatchee, WABuilt 2004 · S/N 560-0659N74GRRobinson George A IV · Houston, TXBuilt 2006 · S/N 560-0704N774SBAirmed International LLC · Birmingham, ALBuilt 2005 · S/N 560-0684N801CBBaugh Aviation Services LLC · Orem, UTBuilt 2001 · S/N 560-0584N807BWTejama LLC · Amarillo, TXBuilt 2003 · S/N 560-0640N807JCGwu LLC · Saint James, MOBuilt 2002 · S/N 560-0602N818SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2001 · S/N 560-0581N819SHSilverhawk Aviation Inc · Lincoln, NEBuilt 2002 · S/N 560-0604N823CBThunderbird Equipment LLC · Hillsboro Beach, FLBuilt 2006 · S/N 560-0697N845ATApalach Adventures LLC · Chattanooga, TNBuilt 2000 · S/N 560-0547N856ACVision Jet LLC · Fort Wayne, INBuilt 2004 · S/N 560-0656N87SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 560-0616N884RCJannenga Air LLC · Phoenix, AZBuilt 2001 · S/N 560-0552N888GDCluheir LLC · Van, TXBuilt 2002 · S/N 560-0634N89MDFuturesource Capital Corp · Bismarck, NDBuilt 2002 · S/N 560-0612N89PR603 Holdings LLC · Aberdeen, SDBuilt 2002 · S/N 560-0603N912DPVista Services LLC · Madison, WIBuilt 2001 · S/N 560-0575N927PKSymmetry Aviation LLC · Mount Pleasant, TXBuilt 2001 · S/N 560-0551N933PBApp Concepts LLC · Wichita, KSBuilt 2002 · S/N 560-0618N958GBHawkeye Asset Management & Consulting Services LLC · Kilgore, TXBuilt 2004 · S/N 560-0680N962KCD & D Aviation Inc · Olathe, KSBuilt 2004 · S/N 560-0670N977MRN977mr LLC · Pagosa Springs, COBuilt 2002 · S/N 560-0623N978MAN978ma LLC · Eaton, COBuilt 2005 · S/N 560-0683N979PWFlight By Pwi LLC · Nappanee, INBuilt 2004 · S/N 560-0650
Back to AD 2006-08-13