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.

N424MJTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 1997 · S/N 3449107N424PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843468N424PBDavis John W · Sugar Land, TXBuilt 2015 · S/N 4277N424PMCdhnv LLC · Santa Fe Springs, CABuilt 2007 · S/N 4697288N424RSRomeo Sierra LLC · Acworth, GABuilt 2025 · S/N 10604N424SGAt Holdco LLC · San Antonio, TXBuilt 2001 · S/N 4697039N424SRMartin Gary D · Plano, TXBuilt 2007 · S/N 2464N424SWPrestige Worldwide Sr22 LLC · Caldwell, IDBuilt 2009 · S/N 3380N424TATamkin Asset Management LLC · Malibu, CABuilt 1981 · S/N 34-8133044N424TFHalf Penny Hangar Inc · Houston, TXBuilt 2022 · S/N 2881552N424XBespinx LLC · Austin, TXBuilt 2014 · S/N 4153N424XCEchelbarger Todd · Edmonds, WABuilt 1990 · S/N 344-8005N4252QPoage Thomas F · Sacramento, CABuilt 1977 · S/N 28-7716174N425AVWestwind School Or Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8877N425BVBvi Air LLC · Grand Forks, NDBuilt 2014 · S/N 4158N425CDDtn Aviation LLC · Winona, MNBuilt 2004 · S/N 0892N425CGSchmiesing Brothers Aviation Ltd · Minster, OHBuilt 2007 · S/N 2814N425HNovak Matthew T · Dundee, ORS/N 4636288N425HACci Air LLC · Albion, MIBuilt 2004 · S/N 3246219N425JAWhiskey Tango Fox LLC · Portland, ORBuilt 2007 · S/N 2452N425MHN425mh LLC · Geismar, LABuilt 2017 · S/N 4517N425MSMcdonald Shane · Belmont, MSBuilt 2005 · S/N 1256N425MTRkg Enterprises · Hibbing, MNBuilt 2015 · S/N 4201N425PABas Part Sales LLC · Greeley, COBuilt 2001 · S/N 2843474N425SJCook Christopher J · Baxley, GABuilt 2003 · S/N 1342N425W4js LLC · Holland, MIBuilt 1978 · S/N LW268N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647N4268FWindt Edward A Jr · Chester, NJS/N 28-7790008N426AHClear Prop Aviation LLC · Potomac, MDBuilt 2021 · S/N 2740N426BGZulu Golf LLC · Henderson, NVBuilt 2026 · S/N 11277N426BLRice Developments LLC · Walker, LABuilt 2022 · S/N 8653N426CDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11329N426DJNehoc Leasing LLC · Marietta, GABuilt 2019 · S/N 4867N426EEdgewater LLC · North Charleston, SCBuilt 2016 · S/N 2315N426GSEmpire Crushing LLC · Wake Forest, NCBuilt 2006 · S/N 41629N426GWNottingham Holdings LLC · Bluffton, SCBuilt 2017 · S/N 4520N426MRRonkin Skyways LLC · Sharon, MABuilt 2025 · S/N 10642N426PAN426pa LLC · New Orleans, LABuilt 2001 · S/N 2843475N426PRRyka Aviation LLC · Sunrise Beach, MOBuilt 1999 · S/N 3257108N426RMRocky Mountain College · Billings, MTBuilt 2002 · S/N 2843529N426SEAthena Aviation LLC · Golden, MSS/N 3255042N426SRSchoeneman Michael D · Central Point, ORBuilt 2006 · S/N 2205N426SSCirrus Design Corp · Duluth, MNS/N 11739N426TC3di LLC · Elizabeth, WVBuilt 1987 · S/N 4622001N426WVAbhrdh Enterprises LLC · Bunker Hill, WVBuilt 2025 · S/N 10548N427ABSouthern Fabrication & Welding LLC · El Dorado, ARS/N 4636324N427ATMockingbird LLC · Bloomington, INBuilt 2004 · S/N 0954N427CQStinger Capital Partners LLC · Eads, TNBuilt 2002 · S/N 40.255N427HPBohannon Brian · Prosper, TXBuilt 2005 · S/N 1528N427JKMoore J R · Montgomery, TXBuilt 1997 · S/N 3246061
Back to AD 2008-06-28 R1