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.

N289JGNex Gen Paving Inc · Sanford, TXBuilt 1998 · S/N 3257030N289KMAe Aero LLC · Newtown Square, PABuilt 2020 · S/N 2614N289MJJ-Com Aviation LLC · Richland, MSBuilt 2007 · S/N 3257472N289PCdr Development LLC · Houston, TXBuilt 2007 · S/N 3257444N289SBHemcka Aviation LLC · Bradenton, FLBuilt 2004 · S/N 1102N289STSml Aviation LLC · Parker, COBuilt 2018 · S/N 2881039N28AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843781N28BJBj Aviation Inc · Littleton, COBuilt 1996 · S/N 34-47017N28BKMooster Aviation LLC · Niceville, FLBuilt 2023 · S/N 9199N28BXBoyle Brendan C · Apex, NCBuilt 2025 · S/N 10904N28DTSilverstreak Aviation LLC · The Villages, FLBuilt 2002 · S/N 2843534N28FNValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10834N28JAJersey Aero Club Inc · Lakewood, NJBuilt 1982 · S/N 28-8290137N28JCCirrus Design Corp · Duluth, MNS/N 11687N28JKTorps LLC · Southlake, TXBuilt 1998 · S/N 4636164N28KUIal Corp · Lewes, DES/N 2881142N28MACirrus Design Corp · Duluth, MNS/N 11785N28MBMockingbird Flying Club Inc · Sioux Falls, SDBuilt 1980 · S/N 28-8090292N28NCHurley Thomas W · Plymouth, MABuilt 1968 · S/N 28R-30357N28NSMockingbird Flying Club · Sioux Falls, SDBuilt 1976 · S/N 28-7790227N28NWFixed Gear Sportsman LLC · Seattle, WABuilt 2017 · S/N 4540N28PDBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 41776N28PFOcf Air LLC · Phoenix, AZBuilt 2011 · S/N 2085N28PGLane Community Colleg · Eugene, ORBuilt 1979 · S/N 28-7916405N28PPPiper Aircraft Inc · Vero Beach, FLBuilt 2019 · S/N 2881041N28PZAsa Obion LLC · Union City, TNBuilt 2006 · S/N 3257418N28RInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 2890202N28SCDouville Kenneth · Derry, NHBuilt 2001 · S/N 1137N28STParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020129N28TKLos Cielos Flyers LLC · San Antonio, TXBuilt 2002 · S/N 0263N28VUPhysicians Air Transport LLC · Hot Springs, ARBuilt 1980 · S/N BB-743N2901ALa Hoz Bruno · Canyon Country, CABuilt 1979 · S/N 28-7916524N2901BShouling & Philip Enterprise · Lancaster, CAS/N 28-7916525N2901HParis Air Inc · Vero Beach, FLS/N 28-7916526N2901QJupiter Flight Service And Investing LLC · Lithonia, GAS/N 28-7916528N2901TCoast 2 Coast LLC · Pensacola, FLS/N 28-7916529N2902BSky Angel LLC · Sikeston, MOBuilt 1979 · S/N 28-7990538N2902RN2902r LLC · Kenosha, WIS/N 28-7990539N2902SM81 Aviation LLC · Santa Monica, CABuilt 1979 · S/N 28-7990540N2903ADynasty Adventure Inc · Mentone, CAS/N 28-7990541N2903DBecker Paul J · Spring Hill, FLBuilt 1979 · S/N 28-7990542N29049Weiman Magnus · Lynchburg, VABuilt 1979 · S/N 28-7990429N2908YAnco Air Inc · Weston, FLS/N 32R-8129100N29098Gill Stuart W Jr · Kingsport, TNBuilt 1979 · S/N 28-7990436N2909QHelman Tom · Evanston, WYBuilt 1979 · S/N 28-7916533N290CDMenezes Marcelo Vianna · Hampstead, NCBuilt 2002 · S/N 1167N290DSNakel Inc · Elkton, SDBuilt 2003 · S/N 40.290N290JCirco Industries 2 LLC · Belle Chasse, LABuilt 2006 · S/N 1920N290KAir Ems Inc · Tulsa, OKBuilt 1980 · S/N LW-337N290KAN290ka LLC · Clare, MIBuilt 1974 · S/N LW59
Back to AD 2008-06-28 R1