Registered aircraft · 30

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

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:99-15-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:99-15-13') ORDER BY n_number

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:99-15-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:99-15-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.

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:99-15-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:99-15-13')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N121DPOrindgreff John Michael Trustee · Wichita, KSBuilt 1994 · S/N 26027 N135NAWolf-Dietrich Weber · San Jose, CABuilt 2001 · S/N 26184 N199MSKennedy Nicholas P · Telluride, COBuilt 1997 · S/N 26123 N213WKNorthcutt Randy A · Alpine, WYS/N 26213 N223MPHogue James H · Birmingham, ALBuilt 2008 · S/N 26253 N25EEDingess James David · Carson City, NVBuilt 1994 · S/N 26028 N269DGHeneghan Tim S · Auburn, WABuilt 2003 · S/N 26210 N26DXLinnekin Dennis · El Dorado Hills, CAS/N 26242 N26EKNeigher Alexander Samuel · South Lake Tahoe, CAS/N 26187 N26GGBarry Colin J · Erie, COBuilt 2006 · S/N 26235 N26GJFitch Jonathan · Napa, CABuilt 1998 · S/N 26141 N26QXUp Up And Away LLC · Kalispell, MTBuilt 2005 · S/N 26226 N26WDD2d Corp · Franktown, COBuilt 1995 · S/N 26039 N26XXGoodrich William R · Corinne, UTS/N 26218 N326AGreenwell Eric N Trustee · Richland, WABuilt 1995 · S/N 26043 N430JAStallman Jon Michael · Chico, CAS/N 26196 N4500EOwens Russell A Trustee · San Diego, CAS/N 26182 N455SZimmerman Walker D · Nashville, TNBuilt 2001 · S/N 26183 N50FUKinsell David A · Windsor, COBuilt 2007 · S/N 26248 N52ZZBargainnier David R · Reedsville, PABuilt 2002 · S/N 26197 N644CCSchemmer Glenn Kenneth · Park City, UTBuilt 2000 · S/N 26170 N66DYBamberg Michael L · Hillsboro, ORBuilt 2002 · S/N 26195 N802JSFried Stephen S · Kingston, MAS/N 26124 N80BMDanieli Barry R · El Verano, CABuilt 1995 · S/N 26042 N893KRDelaney Timothy P · Montrose, COBuilt 2001 · S/N 26186 N907KKnecht Ken L · Eagle River, AKBuilt 2008 · S/N 26254 N92STGreaves Wade P · Saint Paul, ORBuilt 2006 · S/N 26234 N951AKFlagg Charles N · Bellport, NYBuilt 2004 · S/N 26225 N960KBByers Wendell Shaw Jr · Omaha, NEBuilt 2007 · S/N 26251 N961JMMedley John A III Trustee · Thousand Oaks, CABuilt 1994 · S/N 26012

Back to AD 99-15-13