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.

N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N203TSQualitair LLC Trustee · MichelstadtS/N 40.973N203USSalter Equipment Leasing LLC · Natchitoches, LABuilt 2008 · S/N 40.903N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242N2048MMiller Gerald L · Selinsgrove, PABuilt 1977 · S/N 28-7816244N204BRRand Joseph · Osprey, FLBuilt 2002 · S/N 0248N204DLVictor Tango Holdings LLC · Darlington, MDBuilt 2008 · S/N 1942N204EAEtheredge Mark · Pell City, ALBuilt 2023 · S/N 28020119N204NGTrident Aircraft Leasing LLC · Easton, MDBuilt 2014 · S/N 2271N204RESchwartz Group LLC · Bozeman, MTBuilt 2004 · S/N 1429N204RMBar Air LLC · Beverly Hills, CABuilt 2015 · S/N 2295N204SGSquillace Daniel J · Cary, NCBuilt 2005 · S/N 40.482N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115N204VTVictor Tango LLC · Kailua Kona, HIBuilt 2006 · S/N 1605N2050DSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2002 · S/N 1191N2052MDehnel Kris P · Cedar Park, TXS/N 28-7890222N2054MMcdonald Patrick R · Waverly Township, PABuilt 1977 · S/N 28-7890223N205APPappalardo Anthony · Vero Beach, FLBuilt 2000 · S/N 46-36250N205DSUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 2002 · S/N 40.205N205ECEsa Aviation LLC · Lemont, ILBuilt 2012 · S/N 2127N205FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020205N205LBLima Bravo Holdings LLC · Powell, OHBuilt 2012 · S/N 2216N205SGWilliams Christopher · Wallingford, KYBuilt 2005 · S/N 3255041N205THAaces Flight Operations LLC · Ellisville, MOBuilt 1981 · S/N 28-8190282N205ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881606N2069MSeton Perry · Casper, WYBuilt 1977 · S/N 28-7816247N206ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496036N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466N2070MD&L Aviations LLC · Breckenridge, TXBuilt 1977 · S/N 28-7890226N2075TBarakat LLC · Little Rock, ARBuilt 2000 · S/N 1075N20784Dbab LLC · Belleville, ILBuilt 1978 · S/N 28-7990025N2079NSkywarrior Flight Training Inc · Pensacola, FLBuilt 1979 · S/N 44-7995214N2079WCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 44-7995270N207ABCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841284N207CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881001N207DVWiseman Charles N · Midland, MIBuilt 2002 · S/N 0183N207ESPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020254N207SLLost Horizon LLC · Brunswick, MEBuilt 2025 · S/N 10939N207SSTm Aero LLC · Riverview, FLBuilt 1980 · S/N 441-0136N207WMG A Associates LLC · Port Orange, FLBuilt 2008 · S/N 3360N2080VMcguire Rental Properties LLC · Prescott, ARBuilt 1979 · S/N 28-7916322N20816Dawson Matthew · Springfield, MOBuilt 1980 · S/N 32R-8029001N2081CTrident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7916128N2083DSale Reported · Crystal, MNSale reportedBuilt 1978 · S/N 44-7995126N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253
Back to AD 2008-06-28 R1