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.

N711STHalabi Aviation 2 LLC · Foster City, CABuilt 2012 · S/N 4692179N711VRCjw Real Estate LLC · Haddonfield, NJBuilt 2006 · S/N 41715N711WCBateman Randy · Lindale, TXBuilt 1994 · S/N 3448049N711XXJci Leasing LLC · Moultrie, GABuilt 2023 · S/N 9242N711YDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 40.535N7120EFlightgest Academy LLC · Morrisville, NCBuilt 2021 · S/N 4496471N7122EChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 4496447N712ATWegner Cole Aviation LLC · Lincoln, NEBuilt 2017 · S/N 4518N712BLMs Air LLC · Hickory, NCBuilt 2008 · S/N 4692027N712CDLamadera Enterprises LLC · Lufkin, TXBuilt 2001 · S/N 0027N712HAHa Aviation LLC · Greenville, SCBuilt 2022 · S/N 8711N712MBZero 24 Interests LLC · Houston, TXBuilt 2025 · S/N 10711N712PAUtah State University · Logan, UTBuilt 2008 · S/N 40.912N712RALone Mountain Aircraft LLC · Vandalia, OHBuilt 2006 · S/N 1933N712RMCrown H Cirrus LLC · Casscoe, ARBuilt 2020 · S/N 4946N712RXWhiskey Kilo LLC · Monroe, LABuilt 2020 · S/N 4902N712SCKilo-Seven Aviation LLC · Annapolis, MDBuilt 2025 · S/N 10574N712TARmag LLC · Corpus Christi, TXBuilt 2021 · S/N 2737N71357Horn Associates 2 LLC · Brookline, MABuilt 2026 · S/N 11349N713CDCamoin Robert J II · Suffield, CTBuilt 2005 · S/N 1642N713DWSierra Group LLC · Bend, ORBuilt 2006 · S/N 41694N713GGLomi Aviation LLC · Houston, TXS/N 3090N713LSMendel Joseph · Naperville, ILBuilt 1978 · S/N 28-7890400N713NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843882N713RDGrow Rich LLC · Wilmington, DEBuilt 2004 · S/N 0904N713REAks Aviation LLC · Arroyo Grande, CABuilt 1983 · S/N 28-8316083N713SBAnderson Adam Lee · Loomis, CABuilt 2005 · S/N 1297N713SQTransportation Solutions & Logistics Inc · Orlando, FLBuilt 2013 · S/N 2843735N713SRMike & Matts Plane LLC · Brooklyn, NYBuilt 2007 · S/N 2480N713TASutton Logistics LLC · Hayward, WIBuilt 2020 · S/N 2636N713WATempus Fugit LLC · Henderson, COBuilt 2013 · S/N 4697525N714BRNickell Ventures LLC · Sheridan, WYBuilt 2006 · S/N 41661N714EDKirkland Stephen M · Winston Salem, NCBuilt 1998 · S/N 3246117N714GMYates Management Partners LLC · Brentwood, TNBuilt 2019 · S/N 2469N714JMJ&S Landings LLC · Gypsum, COBuilt 2008 · S/N 411121N714KJShortt Aircraft Leasing LLC · South Lyon, MIBuilt 2007 · S/N 40.888N714KLMatera Management LLC · Spanish Fork, UTBuilt 2002 · S/N 4636328N714NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843883N71562Kalche Aviation LLC · Baton Rouge, LABuilt 2001 · S/N 4697081N7158CAeronauts Flying Club Inc · Newton, MABuilt 1975 · S/N 28-7690057N715BBMartin L Jeffrey · Hudson, OHBuilt 1996 · S/N 4636038N715CDRegistered aircraftSale reportedBuilt 2001 · S/N 0016N715CRCrv Aviation LLC · Palmetto Bay, FLBuilt 2020 · S/N 4948N715EMCloud 9 Aviators LLC · Lake Zurich, ILBuilt 2025 · S/N 10917N715JGBz Air LLC · Lebanon, NJBuilt 2026 · S/N 11312N715JNHerman David Trustee · Chesapeake, VABuilt 2013 · S/N 3958N715JPSk Air LLC · Federalsburg, MDBuilt 2017 · S/N 4549N715LMIntepros Inc · Jupiter, FLBuilt 1998 · S/N 4636173N715LPN715lp LLC · Sarasota, FLBuilt 2016 · S/N 4411N715MHHill Michelle · Yreka, CAS/N 4140
Back to AD 2008-06-28 R1