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.

N427KGWhite James J IV · Conroe, TXBuilt 2008 · S/N 3068N427LCP D Capital LLC · San Diego, CABuilt 2006 · S/N 1626N427LJBeach Richard J · Novato, CABuilt 2019 · S/N 2513N427PASeigars Richard M · Port Orange, FLBuilt 2008 · S/N 411096N427RMWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 2843531N427SRTrosclair Air LLC · Gonzales, LABuilt 2007 · S/N 2432N427TXMayfly Holdings LLC · Monticello, FLBuilt 2008 · S/N 421007N427WSMijares Miguel · Mcallen, TXBuilt 2001 · S/N 4636321N4280FRt Flyers LLC · Shakopee, MNBuilt 1976 · S/N 28-7790009N428AMT G Mendell Corp · New York, NYBuilt 2020 · S/N 4896N428ANPatriot Flyers LLC · Lake Havasu City, AZBuilt 2006 · S/N 2092N428APPaper Plane Aviation LLC · Sharpsburg, GABuilt 2026 · S/N 11406N428BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010046N428CCN428cc LLC · Kennesaw, GABuilt 2025 · S/N 10780N428CDGj Aaberg Files LLC · Bloomington, ILBuilt 2026 · S/N 11359N428DSHu Xihao · Indianapolis, INBuilt 2001 · S/N 40028N428JPCal Aircraft LLC · Lewes, DEBuilt 2004 · S/N 40.426N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169N428NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010014N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476N428SPStar Flight LLC · Johns Creek, GABuilt 2003 · S/N 40.283N428SRLautman Karl F Trustee · Los Angeles, CABuilt 2006 · S/N 2258N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167N428XWillett Kyler James · Burbank, CABuilt 2008 · S/N 411076N428ZZDeans List Aviation LLC · Nashville, TNBuilt 2020 · S/N 4987N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036N4292KPakiri Aviation LLC · San Antonio, TXS/N 32R-8329013N4292SD&D Design Manufacturing Inc · Oklahoma City, OKBuilt 1983 · S/N 32R-8329014N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037N4293XTimothy G Turner · Oklahoma City, OKBuilt 1983 · S/N 34-8333043N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040N4294NCoastal Aviation LLC · Virginia Beach, VABuilt 1983 · S/N 32R-8313011N4294PAex Enterprises LLC · Alexandria, LABuilt 1983 · S/N 32R-8329015N42979Dashanddash LLC · Athens, GABuilt 1983 · S/N 32R-8329021N4297CEv Aviation LLC · Elizabeth, COBuilt 1983 · S/N 32R-8329019N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050N42987Gman Air LLC · Clayton, MOBuilt 1983 · S/N 32R-8313017N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058N4298VLuitjens Jabob J · Cascade Locks, ORS/N 28-8316059N42990Montemayor Anselmo · Duncanville, TXS/N 32R-8329024N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064N429DSCalifornia Industrial Rubber Co Inc · Fresno, CAS/N 40.1139N429SBieker James · Eatonville, WABuilt 2004 · S/N 1399N429SRN205bp LLC · Sheridan, WYBuilt 2007 · S/N 2686N42BELasalle Management Company LLC · Ruston, LAS/N 3903N42BGGtw Aviation LLC · San Jose, CABuilt 2008 · S/N 4697369N42BZStratum Breeze LLC · Mount Pleasant, SCBuilt 2026 · S/N 11231N42KRDonnelly Charles A · Browns Mills, NJBuilt 1977 · S/N 28-7716295
Back to AD 2008-06-28 R1