OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N9298JSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1997 · S/N 2843107N9298LLangenberg Stewart M · Santa Barbara, CABuilt 1998 · S/N 3246108N9298NDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1997 · S/N 3257005N9298PBlackhawk Airventures LLC · Wilmington, DEBuilt 1997 · S/N 3246088N9299BBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843116N9299PFusion Flight Management LLC · Lake Havasu City, AZBuilt 1997 · S/N 4636123N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021N929AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843803N929AMM&M Flying LLC · Boston, MABuilt 2021 · S/N 5024N929BLFactora Property Management LLC · Bloomington, INBuilt 2008 · S/N 2898N929CDBb Co LLC · Englewood, COBuilt 2024 · S/N 10045N929CPSpark Aviation LLC · Shreveport, LAS/N 0856N929CVCrotts Jacob · Sylva, NCBuilt 2014 · S/N 4697575N929DABiomedical Holdings LLC · Bountiful, UTBuilt 2014 · S/N 4697573N929DEDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0293N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344N929DRAir Force Two LLC · Superior, WIS/N 4441N929HG929hg LLC · Scottsdale, AZBuilt 2018 · S/N 2460N929JWAlift LLC · Fairhope, ALBuilt 2015 · S/N 2296N929MBRock Aviation LLC · Ankeny, IABuilt 2025 · S/N 10456N929MGAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2006 · S/N 1792N929PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843299N929RSchneider Franz · Bacliff, TXBuilt 2001 · S/N 0133N929RRPanafax LLC · Wilmington, DEBuilt 1997 · S/N 4636115N929SEHogge William Edward · Pageland, SCBuilt 2006 · S/N 2244N929TMMathson Timothy R Trustee · Mosinee, WIBuilt 2005 · S/N 1568N929WSecond Star To The Right Aviation LLC · Atlanta, GABuilt 2025 · S/N 11050N929ZABearcat Aviation LLC · Chester, NJBuilt 2011 · S/N 3818N92APRaven Aircraft LLC · Prescott, AZBuilt 2016 · S/N 4636686N92BZWhelan Holdings LLC · Howardstown, KYBuilt 2004 · S/N 0908N92CDZeneski Andrew J Sr · Wake Forest, NCBuilt 2002 · S/N 0299N92DVMile Hi Skydivers Inc · Longmont, COS/N LW-292N92FZStrawman Aviation LLC · Auburn, INBuilt 2014 · S/N 4636645N92GRMarrero Teresa · Jayuya, PRS/N 28-7816159N92HDN242ak LLC · Ocala, FLBuilt 2003 · S/N 3257326N92JDDc Transit LLC · Juneau, WIBuilt 2004 · S/N 1468N92JQTasair LLC · Minocqua, WIS/N 441-0223N92JRInternational Air Services Inc Trustee · Carson City, NVS/N 1097N92LLTanner Dave · Auburn, CABuilt 2000 · S/N 3257191N92WFNpp Aviation I LLC · Teton Village, WYS/N 3763N930ABInner Path Aviation LLC · New Canaan, CTBuilt 2023 · S/N 9496N930DGBieker James M · Eatonville, WABuilt 2020 · S/N 4935N930ERDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2002 · S/N 4496154N930HMForgenie Alan Peter · Willsboro, NYBuilt 2005 · S/N 4697236N930KGGriggs Roger · Columbia, SCS/N 32R-8029027N930KHDirt Aviation LLC · Rome, GABuilt 2002 · S/N 0317N930KMPiper Meridian LLC · Greenwood Village, COBuilt 2008 · S/N 4697365N930LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496418N930MAPlaceway Scott M · Lapeer, MIBuilt 2020 · S/N 2881404N930PGN930pg LLC · New York, NYBuilt 2002 · S/N 1224
Back to AD 2008-06-28 R1