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.

N383PTFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881603N383SRCoscia Joseph R · Granite Bay, CABuilt 2006 · S/N 2164N383SSJoseph Skilken & Co Inc · Columbus, OHBuilt 1980 · S/N 441-0161N383TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10629N38409Straub Craig W · San Martin, CABuilt 1977 · S/N 28-7790255N38411N38411 LLC · Bellevue, WABuilt 1977 · S/N 28-7790356N38412Rekaa Enterprises LLC · Paragould, ARBuilt 1977 · S/N 28-7716251N38421Sale Reported · Ephrata, WASale reported, pending cancellationBuilt 1977 · S/N 28-7790551N38433Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716254N38434Wheeler Jeffrey Scott · Hampstead, NCBuilt 1977 · S/N 28-7790553N3845TBakrevski Lupcho · Valparaiso, INBuilt 1967 · S/N 28R-30165N3846Osyka LLC · Sheridan, WYBuilt 1967 · S/N 28R-30167N3847TBay Air Inc · Bay City, MIBuilt 1967 · S/N 28R-30168N38480Klose Frank · Rochester Hills, MIBuilt 1977 · S/N 28-7716260N38483Kdrd Holdings LLC · Texas City, TXS/N 28-7790556N3848TNextgen Flight Acacemy Inc · Riverside, CAS/N 28R-30169N38492Toureau John H · Chesterfield, MIBuilt 1977 · S/N 28-7716261N38494Hannon Joseph S · Franklin, NHBuilt 1977 · S/N 28-7716262N384ADRltw LLC · Scottsdale, AZBuilt 2008 · S/N 411008N384APApf3 Holdings LLC LLC · Buffalo, MNBuilt 2026 · S/N 11079N384BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010038N384CAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 0427N384CAUtah State University · Logan, UTBuilt 2006 · S/N 40.734N384CPAlley Shawn E · Albany, ORBuilt 2007 · S/N 1872N384DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843846N384DEDestinations Efc LLC · Tulsa, OKBuilt 2021 · S/N 5091N384DMVolair Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 40.443N384DSJs Aviation Holdings LLC · Warner Robins, GABuilt 2008 · S/N 40.1037N384GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881430N384HSClear Prop LLC · Murfreesboro, TNBuilt 1977 · S/N 28-7790550N384SRRegistered aircraftBuilt 2006 · S/N 2261N384TSTexas Southern University · Houston, TXBuilt 2025 · S/N 10693N38517Stillway Dennis Trustee · Vallejo, CABuilt 1977 · S/N 28-7790558N3851CAbb Aviation LLC · Burnsville, MNBuilt 2005 · S/N 1637N3851TSkyview Aviation LLC · Tracy, CABuilt 1967 · S/N 28R-30173N38522Radcliffe Joshua Kyle · Atlanta, GAS/N 28-7816180N3852TB & B Aircraft LLC · Norcross, GABuilt 1967 · S/N 28R-30174N38549Cohesive Aviation LLC · Gilford, NHS/N 28-7716268N38553Cherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 28-7790563N3855MPramik Edward J · Norton, OHBuilt 1978 · S/N 28-7816381N3855TEskridge William M · Cheraw, SCBuilt 1967 · S/N 28R-30178N3856TB & B Flying LLC · Huntingburg, INBuilt 1967 · S/N 28R-30179N38577Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716201N3857TAmt Services LLC · Virginia Beach, VABuilt 1967 · S/N 28R-30180N3858MMachias Auto Parts Inc · Jonesport, MEBuilt 1978 · S/N 28-7816628N3858TFlying Dots LLC · Daytona Beach, FLBuilt 1967 · S/N 28R-30181N38599Collum Aviation LLC · Milton, FLS/N 28-7716271N3859MWhite Roger L · Wallins Creek, KYS/N 28-7890336N3859TYurek Allen L · Fairfax, VABuilt 1967 · S/N 28R-30182N385CFoster Harry A · Birmingham, ALBuilt 2002 · S/N 0433
Back to AD 2008-06-28 R1