OpenAirDocs.org
AD 2003-26-06

Registered aircraft · 1,566

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

N101GQBankruptcy Services LLC · Wilmington, DEBuilt 2018 · S/N 1262N101MDHolt Aviation LLC · Clear Lake, IABuilt 2015 · S/N 1085N1024SAether Aircraft LLC · Roseville, MNBuilt 2011 · S/N 586N103JDCentaur Aviation Co LLC · Spring, TXBuilt 2012 · S/N 619N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585N104EHaas Bruce F · Lynden, WAS/N 586N105TMJetnexa Twelve LLC · Gilbert, AZBuilt 2021 · S/N 1383N105UTobago Six Inc · Bellevue, WAS/N 591N106FI A Lele LLC · Great Falls, VAS/N 592N107FRjm Aviation Partners Inc · Naples, FLBuilt 1986 · S/N 599N107VJdj Endeavours LLC · Downers Grove, ILBuilt 1986 · S/N 601N108CRCambridge Investment Group Inc · Fairfield, IABuilt 2006 · S/N 347N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080N108YGoduto Aeronautics LLC · Monroe, CTS/N 594N109TALima Whiskey Alpha LLC · Missoula, MTBuilt 1998 · S/N 3103N10VWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 1454N110RPCalamigo Management Company LLC · Santa Barbara, CABuilt 2023 · S/N 1504N110UDarnell Charlie · Eads, TNS/N 595N111RFEaston Air LLC · Middletown, RIBuilt 2003 · S/N 259N112ADfss LLC · Henderson, NVS/N 602N112VLebanon Valley Mobile Homes Inc · Palmyra, PAS/N 605N113ACInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 2121N113MVRettig Air LLC · Riverside, CABuilt 2003 · S/N 2193N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N114YMValiair Lc Trustee · Casper, WYS/N 514N115DSOverly Christopher Daniel · Williamsport, OHBuilt 2000 · S/N 2028N115JHanson John Eric · Livermore, CABuilt 1986 · S/N 607N115JRTobago4 LLC · Lawrenceville, GABuilt 1989 · S/N 937N115NSprauer Constance D · Kensington, NHS/N 608N115WFFlawless One LLC · Atlanta, GABuilt 2022 · S/N 1425N117HDUS Helicopters Inc · Marshville, NCS/N 3318N117MVBtc Aviation LLC · Rehoboth Beach, DEBuilt 2021 · S/N 1388N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464N1188RAirtrust LLC - 2 - Series 2 Trustee · Sheridan, WYS/N 2200N118RLS&S Aviation Inc DBA · Cameron, WIS/N 1200N11LM11lm Aviation LLC · Saint Petersburg, FLBuilt 2023 · S/N 1507N11MABank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 1232N11TCarlisle Capital Corp · Portsmouth, NHBuilt 2025 · S/N 1609N11VDQualitair LLC Trustee · MichelstadtS/N 2052N11VUTurboair LLC · Akron, OHBuilt 2017 · S/N 1160N11YDSpeed Bird LLC · Cincinnati, OHBuilt 2009 · S/N 500N121HBHallick Air Services LLC · Madison, WIBuilt 2014 · S/N 1016N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682N123ZCJasper Industries Ltd · Mokena, ILBuilt 2002 · S/N 229N124ALTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 1606N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405N1253CEleven1 LLC · Los Altos, CABuilt 2022 · S/N 1444N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904
Back to AD 2003-26-06