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.

N528CAWile Frederick A · Meridian, MSBuilt 2026 · S/N 11208N528DBRegistered aircraftBuilt 2015 · S/N 4248N528DLLlt LLC · Middleton, WIBuilt 2022 · S/N 9004N528GYFrazier Michael · Crofton, MDBuilt 1976 · S/N 28-7690444N528HEKingdom Airworks LLC · Las Vegas, NVBuilt 2005 · S/N 1409N528JAEagle Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020128N528MOcala Gator Aviation LLC · Ocala, FLBuilt 2017 · S/N 4470N528PCWhere 2 LLC · Las Vegas, NVBuilt 2016 · S/N 4404N528PFEarspasm LLC · Brooklyn, NYBuilt 2015 · S/N 4231N528SMSpeedishtong Aviation LLC · Deer Park, ILBuilt 2023 · S/N 9080N528SRAaa Flying Club Inc · Fort Wayne, INS/N 2314N528VVValor Tactical Solutions LLC · Brea, CABuilt 2005 · S/N 1498N52915Lacy Design And Consulting LLC · Franklin, TNBuilt 2004 · S/N 1411N529AJCaiazzo Leonard · Belle Harbor, NYBuilt 2004 · S/N 1242N529BJSar Aviation LLC · Charlton, MABuilt 2024 · S/N 9933N529BKFlying Offices LLC · Princeton, MABuilt 2013 · S/N 4003N529BLLevair LLC · Edmond, OKBuilt 2019 · S/N 4749N529CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 1621N529CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843925N529DARegistration Pending · Travis Afb, CARegistration pendingBuilt 2020 · S/N 2881423N529HCJ&J Aviation LLC · Thedford, NEBuilt 2008 · S/N 4692039N529LBAeronova LLC · Lexington, KYBuilt 2012 · S/N 4636544N529LJRad Equipment Leasing Inc · Austin, TXBuilt 2004 · S/N 40.436N529MKBlue Ryan LLC · Englewood, COBuilt 2005 · S/N 1590N529PMCarolina Express LLC · Fairmont, MNS/N 46-97029N529PVVlahos Aviation LLC · Destin, FLBuilt 2023 · S/N 9508N529RGKarger Kenneth · Graford, TXBuilt 2005 · S/N 3255031N529SRGreaney White & Associates Inc · Valley, ALBuilt 2006 · S/N 2266N529WMPc Aviation LLC · Kanarraville, UTBuilt 1999 · S/N 4636222N52CFBravo Bravo LLC · Olathe, KSBuilt 2023 · S/N 9218N52DGVero Beach Aviation LLC · Vero Beach, FLBuilt 2024 · S/N 10226N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42N52PJJensen Paul · Highland Village, TXBuilt 2004 · S/N 0850N52SAByrd Aircraft Solutions LLC · Dothan, ALBuilt 2006 · S/N 2139N52TCVig Charles R · Prior Lake, MNBuilt 2000 · S/N 3257185N52TJParker Helicopter LLC · Watsonville, CABuilt 2009 · S/N 40.1063N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301N52ZMRankin David F · Magnolia, ARBuilt 2002 · S/N 40.251N53000Mckinna Kiley J · Dakota Dunes, SDBuilt 2004 · S/N 0855N530BPSvrluga Bradley C · Williamstown, MABuilt 2023 · S/N 9562N530CPSkaalen Skeet · Elkhorn, NEBuilt 2008 · S/N 3030N530DCCrosswind Air LLC · Frederick, MDBuilt 2016 · S/N 4636690N530ESki N Sky LLC · Leesburg, VABuilt 2003 · S/N 0575N530ETJm Air LLC · Leesburg, VAS/N 3471N530GLGarmin International Inc · Olathe, KSBuilt 2007 · S/N 2487N530HPCreek Canyon Aviation LLC · Phoenix, AZBuilt 2001 · S/N 4697101N530MARice Solutions LLC · Farmington, NHBuilt 2023 · S/N 4636817N530PCCirrus Design Corp · Knoxville, TNBuilt 2020 · S/N 4981N530ZMccowan Holdings LLC · Lexington, KYBuilt 2006 · S/N 41606N53189Naylor Irvin H Jr · Charlotte, NCBuilt 2001 · S/N 2843434
Back to AD 2008-06-28 R1