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.

N6861JEwart Mark A · Shoreacres, TXBuilt 1976 · S/N 28-7690414N6863FKaminski Joseph J · Port Orange, FLBuilt 1976 · S/N 28-7790169N6865AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496256N68690Locaero Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 2890203N6869RPro Air Media LLC · Sevierville, TNBuilt 2006 · S/N 2121N686ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496289N686CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881130N686DSScheigert Delbert F Jr · Saint Cloud, FLBuilt 2006 · S/N 1957N686JMavity Michael D · Phoenix, AZBuilt 1988 · S/N 2816038N686JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020086N686LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881253N686NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881152N6876JN6876j LLC · Provo, UTBuilt 1976 · S/N 28-7690417N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437N687AVNeal Jeffrey Jay · Scottsdale, AZBuilt 2000 · S/N 3449180N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020087N687KMDiamond Services Co · Woodward, OKBuilt 2011 · S/N 4636517N687LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881266N687NDAscent Aviation Inc · Duluth, MNBuilt 2014 · S/N 4496373N687PWDragonflier LLC · Las Vegas, NVBuilt 2020 · S/N 4923N687WE-Tan Transportation LLC · Malone, WIBuilt 1992 · S/N 4622124N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421N688LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881267N688NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496374N688PCSea J Aviation LLC · Vernon, CTBuilt 2004 · S/N 1450N688PDUnusual Attitudes LLC · Bates City, MOBuilt 2007 · S/N 2398N688SRRsm Enterprises LLC · Helena, MTBuilt 2007 · S/N 2826N6891SAltimeter Aviation Holdings LLC · Pleasanton, CABuilt 2022 · S/N 4636807N6894JPiontek Theodore J · Housatonic, MABuilt 1976 · S/N 28-7690422N6897CSchumann Donald A · Naperville, ILBuilt 1978 · S/N 28-7890384N689BTDoell Brad J · Elsie, NEBuilt 1977 · S/N 28-7890132N689KCMy Terms LLC · Katy, TXBuilt 2016 · S/N 4636689N689LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881272N689NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496375N689PGDidson International Parts Inc · Rantoul, KSBuilt 2008 · S/N 1889N68AMRfa LLC · High Ridge, MOBuilt 2005 · S/N 3255026N68BARegistered aircraftBuilt 2017 · S/N 4585N68BCBb Co LLC · Englewood, COBuilt 2017 · S/N 2357N68CVertical Concepts Inc · Wilmington, DEBuilt 2005 · S/N 40.537N68CPGroesch Charles William · Springfield, ILS/N 4636238N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68DXFreeman David J · Seattle, WABuilt 2002 · S/N 0214N68GTBoon Hong Sim · New York, NYBuilt 2009 · S/N 3596N68GYOwll Aviation LLC · Baton Rouge, LABuilt 2016 · S/N 4364N68HSBlackdog Air LLC · Wilmington, DES/N 441-0331N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850N68LGSak Aviation LLC · Lewes, DEBuilt 2006 · S/N 1660N68LPAvt Holdings II LLC · Winston Salem, NCBuilt 2008 · S/N 411026N68LWWaconda Concepts LLC · Sturgis, SDBuilt 2007 · S/N 41782
Back to AD 2008-06-28 R1