OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,280

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.

N566MA814 Cartmell LLC · Dover, DEBuilt 2008 · S/N 4697391N566MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.304N566SRFutures Aviation Services LLC · Sunny Isles Beach, FLBuilt 2007 · S/N 2864N5676VDave Simpson Aviation Inc · Escondido, CABuilt 1977 · S/N 28-7790494N5679VAir Nautica LLC · Dublin, GAS/N 28-7716197N567ABPiper Aviation LLC · Lewes, DEBuilt 2001 · S/N 0030N567ATIko Aero Services LLC · Natchez, MSBuilt 2006 · S/N 2188N567CTAvion Sr22 LLC · Schaumburg, ILBuilt 2008 · S/N 3205N567DMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2353N567FLRidgeline Assets LLC · Wilmington, DEBuilt 2026 · S/N 4496643N567GJDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N LW95N567JJCarefree Coach LLC · Thayne, WYBuilt 2005 · S/N 41077N567MGHay-Con Aviation LLC · Winter Park, FLBuilt 2007 · S/N 2446N567MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.308N567PAS & H Aviation LLC · Beaumont, TXBuilt 2007 · S/N 2640N567RCpk Capital Holdings LLC · Newark, DES/N 9630N567SRGoal Aircrafts Corp · Orlando, FLBuilt 2006 · S/N 2097N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496N5688FLink John Ernest · Hereford, TXS/N 41566N5689VStardust Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 28-7790498N568CHigh Tech Aviation LLC · Lubbock, TXBuilt 2001 · S/N 3257264N568CAOncore Aviation LLC · Rochester, NYBuilt 2006 · S/N 40.711N568EParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020236N568HPCkinchen Enterprises LLC · Spring, TXBuilt 2007 · S/N 4697306N568KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843890N568MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.312N568RSSingh Ranbir · Porter Ranch, CABuilt 2004 · S/N 1474N568SRHaney Jeffrey · Carrollton, GABuilt 2004 · S/N 1083N5695DVista Air LLC · Boxborough, MABuilt 2026 · S/N 11395N5697VPray Aviation Dr · Augusta, KSS/N 28-7716203N569DSCapitol City Flyers Inc · Madison, WIBuilt 2006 · S/N 40.648N569MLSuburban Farms Inc · Houston, TXBuilt 2025 · S/N 10964N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314N569PGSavvy Investing LLC · Greencastle, INBuilt 2008 · S/N 3003N569SFTaylor Bruce L Jr · Irondale, ALBuilt 2011 · S/N 3739N569STSer Logistics LLC · Marietta, GABuilt 2020 · S/N 4636769N56AHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 2781N56APCka Investments LLC · Mcallen, TXS/N 2768N56BMAtlas Aero LLC · Fargo, NDBuilt 2014 · S/N 4085N56CDDewahl Adventures LLC · Bigfork, MTBuilt 1975 · S/N BB-64N56CXThinair LLC · Dover, DEBuilt 2000 · S/N 4636279N56DACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11556N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56HTLissie 6 LLC · Harlingen, TXFirst renewal noticeBuilt 1977 · S/N LW-215N56LLLegacy Leasing Group Inc · Wilmington, DEBuilt 2007 · S/N 2788N56MBNutacair400 LLC · Deland, FLBuilt 2008 · S/N 411029N56NAHampden Aviation Services Inc · Northampton, MABuilt 1979 · S/N 28-8016073
Back to AD 2008-06-28 R1