OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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:2008-06-28-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:2008-06-28-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.

N88SPSp Aviation LLC · Farmingdale, NYS/N 8861N88VCChandler Van S · Georgetown, TXBuilt 2025 · S/N 10915N88VFMillennial Aviation LLC · Chatsworth, CAS/N 34-8233171N88VMEighty-Eight Victor Mike LLC · Bentleyville, OHBuilt 2025 · S/N 11093N88WDTrmb Aviation LLC · Gulf Breeze, FLBuilt 2018 · S/N 4718N88WFLucky 8 Aviation LLC · Mooresville, NCBuilt 2012 · S/N 3860N88WHThomas Robert R · Rochester, MNBuilt 1968 · S/N 28R-30974N88WZInternational Air Services Inc Trustee · Carson City, NVBuilt 2009 · S/N 3597N88YMEralet Inc · Middletown, DEBuilt 2025 · S/N 10515N88YPBush Michael W · Williamsport, PABuilt 2007 · S/N 2584N8903CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690170N8909MCenterline Aviation LLC · Oro Valley, AZBuilt 2007 · S/N 2368N890CDTrue Course LLC · Lunenburg, MABuilt 2003 · S/N 0591N890DRCirrus Design Corp · Duluth, MNBuilt 2023 · S/N 9750N890GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881070N890NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496603N890SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881800N890UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020196N890USReina Orestes Esteban · Coral Springs, FLBuilt 2008 · S/N 40.890N891AWColonial Aviation LLC · Morristown, NJBuilt 1989 · S/N 4622024N891CDDkw Cirrus 1 LLC · Katy, TXBuilt 2003 · S/N 0592N891CMEagle Vision LLC · Crossville, TNBuilt 2025 · S/N 11065N891DWCirrus Skies LLC · Saint Charles, ILBuilt 2026 · S/N 11217N891NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496555N891TPParsons Aviation LLC · Hooks, TXBuilt 2006 · S/N 42516N8925TSuslavich Frank · Ennis, MTBuilt 1984 · S/N 348433007N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398N892AMVfr Flight I LLC · Longmont, COBuilt 2007 · S/N 2738N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041N892DSR & K Designs LLC · Wake Forest, NCBuilt 2007 · S/N 40.892N892NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496556N893ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881412N893DSNorton Boe L Trustee · Carlsbad, NMBuilt 2006 · S/N 40.743N893NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496505N893QAAia Gulf LLC · Henderson, NVBuilt 2025 · S/N 10755N893SRAdamson Russell · Elk Ridge, UTBuilt 2008 · S/N 2883N89423Sierra Skyport Ltd · Truckee, CABuilt 2014 · S/N 2255N8946CPilawski Darren J · Spring Hill, FLBuilt 1976 · S/N 28-7690171N8948CKrupnik Amnon · Bethesda, MDBuilt 1976 · S/N 28-7690172N894ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881413N894AMFleser Carl R · Sunbury, OHBuilt 2007 · S/N 40.794N894DSWallis Steel C · Las Vegas, NVBuilt 2006 · S/N 40.744N894MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020134N894NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496609N894SAUtah State University · Logan, UTBuilt 2007 · S/N 40.759N894WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10254N895AMMeng Ye · Irvine, CABuilt 2008 · S/N 40.895N895CDCarfinder LLC · Huntington Station, NYBuilt 2003 · S/N 0577N895CMJlb Leasing LLC · Mequon, WIBuilt 2023 · S/N 4636826N895NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496503
Back to AD 2008-06-28 R1