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.

N522LGBagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41609N522MGParker James V · Cashiers, NCFirst renewal noticeBuilt 2003 · S/N 0540N522MJPpr2 Inc · Jackson, MSS/N LW-80N522MKTurbines Ltd · West Point, NEBuilt 2000 · S/N 4636284N522MMSaratoga Aviation Inc · Charleston, SCBuilt 1980 · S/N 32R-8013001N522PMRegistration Pending · Castle Rock, CORegistration pendingS/N 4636568N522PUFlying Club LLC · New York, NYBuilt 2005 · S/N 1561N522RHRoach Kyle Wayne · Lubbock, TXBuilt 2008 · S/N 411038N522SRDias Antonio M · Scottsdale, AZBuilt 2007 · S/N 2475N522VCommodore Aviation LLC · Danville, ALS/N 3951N522WMJaybirds Aviation LLC · Saint Cloud, MNBuilt 2003 · S/N 0670N522WTTme Cirrus LLC · Virginia Beach, VABuilt 2019 · S/N 4823N5231KThree One Kilo LLC · Austin, TXBuilt 1978 · S/N 28-7990042N52326Lehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 2001 · S/N 2843450N5235BBrit Ltd · Wilmington, DEBuilt 2001 · S/N 3257222N5235VAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1417N523AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020050N523BASale Reported · Rexburg, IDSale reportedBuilt 2005 · S/N 41529N523BHColvin Buster · Big Cabin, OKBuilt 1978 · S/N 28-7816546N523CMMelrose Law Pllc · Waynesville, NCBuilt 2018 · S/N 4733N523CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843923N523DAN523da LLC · Warrenton, VABuilt 2024 · S/N 9999N523DLBb Co LLC · Parker, COBuilt 2021 · S/N 2693N523GWA And P Farms LLC · Wilmington, DEBuilt 2019 · S/N 4832N523LSDexalog 12 Optimal Health LLC · Edmond, OKBuilt 2010 · S/N 2058N523LTLima Tango LLC · Norwalk, CTS/N 40.856N523MLForster David · Friendswood, TXBuilt 1989 · S/N 4622087N523PGDe Jesus Benjamin · Deltona, FLBuilt 2008 · S/N 1985N523PUMetro Aircraft Co · Bloomington, MNBuilt 1989 · S/N 2841188N523RKCirrus Design Corp · Duluth, MNS/N 11726N523RSN523rs LLC · Middletown, DEBuilt 2021 · S/N 5071N524ARBlss Aviation Group LLC · Monrovia, CABuilt 2021 · S/N 2757N524CCAubuchon Scott M · Fenton, MIBuilt 2024 · S/N 9796N524CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843924N524DACpi Management Group LLC · Las Vegas, NVBuilt 2015 · S/N 4259N524DSMountain Aviation LLC · Salem, VAS/N 40.260N524ETWanderair LLC · Maple Grove, MNBuilt 2022 · S/N 8798N524JASkyhawk Leasing LLC · Indianapolis, INBuilt 2020 · S/N 28020002N524KCEmanon LLC · Apex, NCBuilt 2004 · S/N 3232030N524MFunny Penguin LLC · North Canton, OHBuilt 1969 · S/N 28R-31101N524MKKarol Mark · Holmdel, NJBuilt 2003 · S/N 1277N524MRMt King Air · Stevensville, MTBuilt 1979 · S/N BB524N524NNielsen Marvin E Jr · Easton, MDBuilt 2002 · S/N 40.235N524PEN524pe LLC · Brookshire, TXBuilt 2025 · S/N 11043N524PGPlane Smart! Aviation LLC · Addison, TXBuilt 2008 · S/N 1986N524PMSky Train Air LLC · Templeton, CABuilt 2000 · S/N 46-97024N524PSOperchal Thomas · Marathon, FLBuilt 2005 · S/N 40.524N524PTLucky Pair Aviation LLC · Ocala, FLBuilt 2024 · S/N 9946N524PUMetro Aircraft Co · Bloomington, MNBuilt 1989 · S/N 2841189N524SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881265
Back to AD 2008-06-28 R1