OpenAirDocs.org
AD 2010-26-05 R1

Registered aircraft · 1,068

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

N81HMIheart Media Management Services Inc · New York, NYBuilt 2000 · S/N 183N81SNK S Blackwood Properties II LLC · Midland, TXBuilt 1999 · S/N 41N820CKKalitta Charters LLC · Ypsilanti, MIBuilt 1967 · S/N 120N822NPProductivity Strategies LLC · Olathe, KSBuilt 1993 · S/N 001N823RCDodson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 201N824SMeregrass Inc · Dublin, TXBuilt 1987 · S/N 23N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025N826APApi Aviation LLC · New Brighton, MNBuilt 2007 · S/N 0123N826KAircraft Fidelity Corp Trustee · Dover, DEBuilt 1998 · S/N 36N827UBcu 2000 LLC · Pleasant Prairie, WIBuilt 2020 · S/N 748N828MLWalkabout Air Inc · Tampa, FLBuilt 1997 · S/N 25N82BULacore Adventures LLC · Melissa, TXBuilt 1988 · S/N 51N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222N831DRDriscolls Inc · Watsonville, CABuilt 2008 · S/N 141N831MSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 430N832WDDodson International Parts Inc · Rantoul, KSS/N 190N833JBImt Holdings Management Co LLC · Sherman Oaks, CABuilt 2004 · S/N 033N83HDHomerlease Co Inc · Atlanta, GABuilt 2017 · S/N 307N83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 288N844UPUnion Pacific Railroad Co · Omaha, NEBuilt 2014 · S/N 287N845UPUnion Pacific Railroad Co · Omaha, NEBuilt 2014 · S/N 727N846UPUnion Pacific Railroad Co · Omaha, NEBuilt 2015 · S/N 729N84HDHomerlease Co Inc · Atlanta, GABuilt 2021 · S/N 325N84PHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 57N84PJHampton Airways Inc · Sellersburg, INBuilt 2015 · S/N 303N84SVSb Air LLC · Winchester, VABuilt 2014 · S/N 291N84TJUsaircraft Inc · Newark, DES/N 188N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326N850FJPachy Music Corp · Bellflower, CABuilt 1991 · S/N 215N850TCRt Falcon Enterprises LLC · Bloomfield Hills, MIBuilt 1999 · S/N 92N851MJet Plane Management LLC · Saint Paul, MNBuilt 2014 · S/N 293N855DGDollar General Corp · Goodlettsville, TNBuilt 2006 · S/N 97N855TJLark Aviation LLC · Reno, NVS/N 19N857SSSimon Aviation LLC · Birmingham, MIS/N 192N858SPBrown Lawson M II · San Diego, CABuilt 1974 · S/N 11N85HDHomerlease Co Inc · Atlanta, GABuilt 2024 · S/N 416N85TNLls Aviation LLC · Nederland, TXBuilt 1993 · S/N 237N860PSLbma Equipment Services Inc · Newburgh, NYBuilt 2021 · S/N 380N865CSReef Aviation LLC · Knoxville, TNBuilt 2004 · S/N 136N865PKPilot Travel Centers LLC · Knoxville, TNBuilt 2013 · S/N 707N865WWRegistered aircraftBuilt 2020 · S/N 367N868AADcco Aviation II LLC · Canton, MIBuilt 2018 · S/N 315N868EMDcco Aviation II LLC · Canton, MIBuilt 2006 · S/N 161N868SHHca Squared LLC · Nashville, TNBuilt 2019 · S/N 360N86HDHomerlease Co Inc · Atlanta, GABuilt 2012 · S/N 250N86TNBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 241N870ARFtc Air Holdings LLC · Tampa, FLBuilt 1997 · S/N 46N870SBSimmons First National Corp · Little Rock, ARBuilt 2019 · S/N 743N874VTGolden Goat LLC · Southern Pines, NCBuilt 1997 · S/N 161N878MMCentury Skies LLC · Englewood, COBuilt 2005 · S/N 51
Back to AD 2010-26-05 R1