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.

N542SRAlliance Solutions Group Inc · Yorktown, VABuilt 2006 · S/N 2213N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120N543CACurtin Terrence R · Lititz, PABuilt 2006 · S/N 41603N543CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881052N543FCGraytail Vision LLC · Dallas, TXBuilt 2025 · S/N 10794N543GWBrown Gregory L · Argyle, TXBuilt 2014 · S/N 4102N543JWUtah State University · Logan, UTS/N 40.358N543LKKilolima3 LLC · Washington, DCBuilt 2021 · S/N 5058N543MWWood Martin J · Ramona, CABuilt 2019 · S/N 4767N543SKGreene Scott P · El Paso, TXBuilt 2004 · S/N 1213N5448FSanford Christopher Evan · Dallas, TXBuilt 1976 · S/N 28-7790124N5449FEngel Rodney · New Prague, MNBuilt 1976 · S/N 28-7790125N544CDAeroplanes LLC · Cary, NCBuilt 2005 · S/N 1544N544CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881053N544NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010013N544PBPortland Patrol Inc · Lake Oswego, ORBuilt 2001 · S/N 3257238N544SWCatherine Michaels Investment Services LLC · Carlsbad, CABuilt 2000 · S/N 2843388N5450FN5450f LLC · Fernandina Beach, FLBuilt 1976 · S/N 28-7790126N5454MMid-South Consultant Pharmacy Services Pllc · Cookeville, TNBuilt 2002 · S/N 1226N5457PA & J Aviation LLC · Cumming, GABuilt 2026 · S/N 11225N545AMMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.526N545CBRegistered aircraftBuilt 2006 · S/N 2134N545CDValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1508N545CP545 Charlie Papa LLC · Colorado Springs, COBuilt 2005 · S/N 1462N545CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881054N545JWBlaise Alexander Management Inc · Muncy, PABuilt 1998 · S/N 4636146N545MASkywest Leasing Inc · St George, UTBuilt 2017 · S/N 2843865N545PMPerseverance Enterprises LLC · Sitka, AKBuilt 2010 · S/N 3703N545RSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 4636668N545WAStine Scott A · Vincennes, INBuilt 1968 · S/N 28R-30577N545WHBledsoe Bobby H · Hot Springs, ARBuilt 2000 · S/N 32-46156N545WTBuilding Restoration Corp · Roseville, MNBuilt 2009 · S/N 3422N546BNavigation Leasing LLC · Castle Rock, COBuilt 2019 · S/N 2881105N546CPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636879N546CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881279N546CDScalini Fernando A · Huntington Beach, CABuilt 2005 · S/N 1627N546CWCentral Washington University · Ellensburg, WABuilt 2019 · S/N 2881104N546KMAero Montana LLC · Greensboro, GABuilt 2008 · S/N 3262N546MAWilliams Joel A · Rocky Face, GABuilt 2007 · S/N 4697331N546MYNti Aviation LLC · Sheridan, WYBuilt 2025 · S/N 10903N546PGDroop Mountain Aviation LLC · Renick, WVBuilt 2008 · S/N 2002N547CHoch Jeffrey · Seattle, WABuilt 2003 · S/N 0484N547CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881383N547DTMcb Family Aviation LLC · Boca Raton, FLBuilt 2024 · S/N 10368N547JS35jp LLC · New Braunfels, TXBuilt 2024 · S/N 9906N547KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843867N547SCSpartan Education LLC · Tulsa, OKS/N 2881322N547SMTrinity Aviation LLC · Rome, GAS/N 1828N548ARDynamic Management LLC · Mobile, ALBuilt 2025 · S/N 10454N548CDEzcow LLC · Bedford, MABuilt 2005 · S/N 1582
Back to AD 2008-06-28 R1