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.

N8309EPlanewright Inc · Newberg, ORBuilt 1983 · S/N 28-8390013N8309KClaridge Michael A · Houston, TXBuilt 1982 · S/N 28-8390015N830BSShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.395N830CAValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11119N830CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0158N830DSFry Craig · Carmel, INBuilt 2006 · S/N 2113N830EGGel Aviation LLC · Farmingdale, NYBuilt 2025 · S/N 10929N830MOliver Firm Lc · Dexter, MOBuilt 1989 · S/N 4622045N830MUMarshall University · Huntington, WVBuilt 2021 · S/N 4496532N830SCFf22 LLC · Scottsdale, AZS/N 2881715N830TCRegistered aircraftBuilt 1980 · S/N 32R-8113016N830WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 10221N83107Second Chance Aviation LLC · Scenery Hill, PAS/N 32R-8129020N8310YRegistration Pending · Kansas City, MORegistration pendingBuilt 1981 · S/N 32R-8113025N83113N83113 LLC · Liberty, NCBuilt 1981 · S/N 28-8116110N8311LSimpson Robert B · South Pasadena, CABuilt 1980 · S/N 28-8116104N8312AToro Aero LLC · Calabasas, CABuilt 1982 · S/N 32R-8313002N8312HAlameda Aero Club · Alameda, CABuilt 1982 · S/N 28-8316020N8312PPerson Timothy Ivan · Lake Stevens, WABuilt 1980 · S/N 28-8190123N8313TBehnfeldt Barry W · Napoleon, OHBuilt 1980 · S/N 32R-8113026N8314BSchultens Robert R Trustee · The Dalles, ORBuilt 1980 · S/N 32R-8129021N8314KRed Dirt Retreat LLC · Colorado Springs, COBuilt 1980 · S/N 32R-8129023N8316EJustfly Inc · Houston, TXBuilt 1980 · S/N 28-8116116N8316STeague Philip · Rattan, OKBuilt 1980 · S/N 28-8190128N83177Nobles Joshua L · Tacoma, WABuilt 1980 · S/N 28-8116118N8317EAppshle Air LLC · Long Beach, CABuilt 1980 · S/N 32R-8113027N8317FLuxairways LLC · Old Bethpage, NYBuilt 1980 · S/N 32R-8113028N83180John Cox LLC · De Witt, NEBuilt 1980 · S/N 28-8190135N83182Devall Kelly · Phoenix, AZBuilt 1982 · S/N 32R-8329011N8318HParra Henry A Torres · Weston, FLS/N 28-8116121N8318QPenn Flight Academy LLC · Quakertown, PABuilt 1980 · S/N 28-8190130N8318YMaverick Air LLC · Wildwood, MOBuilt 1980 · S/N 28-8190134N8319NCapital Aviation LLC · Hickman, NEBuilt 1980 · S/N 32R-8113029N831AMSky Candy LLC · Scottsdale, AZBuilt 2005 · S/N 1578N831AZ847cx LLC · St George, UTBuilt 2001 · S/N 0003N831BAIntered North LLC · Eagle, IDBuilt 2007 · S/N 40.876N831BBVentec LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1999 · S/N 3246135N831CPeck Aerospace LLC · Westminster, MDBuilt 2011 · S/N 4636492N831CCEntrantek LLC · Vancouver, WABuilt 2007 · S/N 2360N831CDNathan Smith Ministries · Belmont, NCBuilt 2005 · S/N 1580N831EDDiaz Edgar · Elmore, ALBuilt 2008 · S/N 3188N831EKPiper Aircraft Inc · Vero Beach, FLS/N 28020288N831JCLaw Office Of Jerome A Clay · Stockton, CABuilt 2003 · S/N 0546N831JDMartinez Alexander J · Cumberland, MEBuilt 2006 · S/N 42506N831JLUtah State University · Logan, UTBuilt 2008 · S/N 40.939N831MUMarshall University · Huntington, WVBuilt 2022 · S/N 8790N831NDCirrus Aviation Inc · Sarasota, FLBuilt 1978 · S/N 28-7816351N831PMAvier LLC · Beverly, MABuilt 2024 · S/N 2881735N831SGDelahoussaye Investments LLC · Leander, TXBuilt 2003 · S/N 0647N831TAN831ta Inc · Port Orange, FLBuilt 2008 · S/N 3150
Back to AD 2008-06-28 R1