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.

N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176N419JSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.439N419MMRegistered aircraftBuilt 2008 · S/N 4692019N419MNSouthern Justice Aviation LLC · Houston, TXBuilt 1980 · S/N BB-785N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413N419SCZeplane LLC · Miami, FLBuilt 1980 · S/N 441-0149N419SRN419sr Inc · Big Pine Key, FLBuilt 2006 · S/N 1650N419STMyers Steven L · Goodyear, AZBuilt 2005 · S/N 1656N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001N41CASale Reported · Trapper C Reek, AKSale reportedBuilt 2017 · S/N 4559N41CDDrewskie Aviation LLC · Norwalk, OHBuilt 2020 · S/N 2557N41DWOne Delta Whiskey LLC · Westport, CTBuilt 2024 · S/N 9802N41EBCoakes Randall S · Lafayette, INBuilt 2004 · S/N 40.445N41JAJersey Aero Club · Lakewood, NJBuilt 1997 · S/N 2843081N41JGRegistration Pending · Farmingdale, NYRegistration pendingBuilt 2026 · S/N 11510N41KBColne Valley Aviation Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8813N41KFThomas Wayne · Powell, OHBuilt 1968 · S/N 28R-30505N41LWSeccombe Stanley G III · Concord, CAS/N 32R-8329031N41MMason Charles · Austin, TXBuilt 2025 · S/N 10719N41MPFlymax LLC · Bellaire, TXBuilt 2024 · S/N 10305N41NVNorth Valley Air Ltd · St Thomas, VIBuilt 1982 · S/N 4410268N41PACtm Aviation LLC · Hattiesburg, MSBuilt 2010 · S/N 40.1103N41PJBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 3708N41PVBear Nathan Eugene · Cove, ORBuilt 1979 · S/N 28-8016063N41SAIntegrated Design And Supply Inc · Crystal Lake, ILBuilt 2005 · S/N 1507N41SMHarper & Co Builders Inc · Douglas, GABuilt 2015 · S/N 4214N41VUDragonfly Aviation LLC · Winder, GABuilt 2018 · S/N 2439N41VVTurner Andrew · Orange Beach, ALBuilt 2004 · S/N 1231N41WAHackler Jeanette D · Arlington, TXBuilt 1967 · S/N 28R-30211N41WVKmfg3 Aero LLC · Barrington, NHBuilt 2014 · S/N 4100N41XPIra Ellis LLC · Jackson, TNBuilt 2002 · S/N 0206N4200BCondair Flyers Inc · Latham, NYBuilt 2000 · S/N 2843319N420AAAka Aviation LLC · Provincetown, MABuilt 2021 · S/N 2712N420AMJun Flying LLC · Godfrey, ILBuilt 2005 · S/N 40.583N420ARArakelian Arthur DBA · Worcester, MABuilt 2000 · S/N 3257149N420BLN420bl LLC · Carmel, INBuilt 2004 · S/N 1234N420CPPerez Jorge A · Mission, TXS/N 1060N420DSPapa Sierra LLC · Huntsville, ALBuilt 2011 · S/N 40.1120N420GWSchell Scott A · Lisbon, NDBuilt 2004 · S/N 1077N420PBZarot LLC · Long Branch, NJBuilt 2003 · S/N 1288N420PYQuantum Electrical Contractors Inc · Palm Coast, FLBuilt 2006 · S/N 4697265N420RMCummiskey Ryan J · Jamesville, NYBuilt 2002 · S/N 2843523N420SEVadola James J Jr · Hillsborough, NJBuilt 2006 · S/N 2293N420SREglin Aero Club · Eglin Afb, FLS/N 1777N420SSZardoz Aviation Inc · Spring, TXBuilt 2022 · S/N 8750N420SUBoelte Aviation LLC · Edmond, OKBuilt 2022 · S/N 8667N420TAElectronic Caregiver Inc · Las Cruces, NMBuilt 1978 · S/N BB-420N420TCBowling Green Flight Center LLC · Bowling Green, OHBuilt 1999 · S/N 2843220N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975N421CShadow Cat Aviation LLC · Fitchburg, WIBuilt 2002 · S/N 0434
Back to AD 2008-06-28 R1