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.

N91YPAircraft Parts Store LLC · Jacksonville, FLS/N 41520N9201ZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841001N9202QRongen Thomas · Fertile, MNBuilt 1993 · S/N 3213052N9203RSouthern Fabrication & Welding LLC · El Dorado, ARBuilt 1993 · S/N 3213044N9205XOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841005N9206NSkylink Xpress Inc · San Bernardino, CABuilt 1990 · S/N 2841301N920ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841216N920AWC P Daniel Properties LLC · Saint Francisville, LABuilt 2006 · S/N 1979N920BCTiger Express Management Company LLC · Isle Of Palms, SCBuilt 2013 · S/N 3994N920BDBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 1211N920CS R Plumbing LLC · Orlando, FLBuilt 2014 · S/N 4636638N920DBColumbia Richard M · Pensacola, FLBuilt 2013 · S/N 4636608N920EDOcs Capital Holdings LLC · White Plains, NYBuilt 2015 · S/N 4240N920ERSunrise Aviation · Ormond Beach, FLBuilt 1993 · S/N 4495013N920LVVendramin Anthony Jr · Chesterton, INBuilt 2003 · S/N 4697159N920MLTrammco Environmental Solutions LLC · Fernandina Beach, FLBuilt 2019 · S/N 4870N920MMDp Aviation LLC · Trenton, NCS/N 42558N920SCStannard Robert W III · Bloomington, INBuilt 2003 · S/N 1292N920XStreamline Aviation LLC · Battlefield, MOBuilt 2014 · S/N 4692206N9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841010N9210NShapiro Sarah Keck · Indianapolis, INBuilt 1993 · S/N 3213046N9210XMills Anthony D · Midland, MIBuilt 1989 · S/N 3213031N92135Jackson Christopher Michael · Clearwater, FLBuilt 1979 · S/N 288090127N9214HJem Aviation Ltd · Wilmington, DEBuilt 1990 · S/N 4622114N9215DToga LLC · Cumming, GABuilt 1990 · S/N 3213037N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229N9219XRud Jay C · Newark, ILBuilt 1994 · S/N 34-48038N921CBDavis David G · Cresson, TXFirst renewal noticeBuilt 1980 · S/N 32R-8129019N921DZPk Helicopters LLC · Graford, TXBuilt 2006 · S/N 41695N921EPValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11655N921GBWalsh Brendan Michael · Yuma, AZBuilt 2007 · S/N 41759N921HRSeligman William P · Kennett Square, PABuilt 2008 · S/N 3121N921KMLo Aircraft LLC · Key West, FLBuilt 2019 · S/N 4636741N921NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881885N921PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843268N921REMojo Aircraft LLC · Lebanon, TNBuilt 2017 · S/N 4524N921RTAd Aviation LLC · Billings, MTBuilt 2018 · S/N 4636725N921TRGt Holdings LLC · Nashville, TNBuilt 2025 · S/N 10435N9220BSchmalenberger Jason R · Hebron, NDBuilt 1993 · S/N 3213048N9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1988 · S/N 2841030N9222QGood Shepherd Leasing Corp · Brooksville, FLBuilt 1993 · S/N 3213051N9223RRegistered aircraftBuilt 1994 · S/N 3448040N9224NBlanchard Aviation LLC · Nazareth, PABuilt 1993 · S/N 3213054N9225CMeriden Aviation Center LLC · Meriden, CTBuilt 1978 · S/N 28-7816447N9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1989 · S/N 2841044N9226CLane Community College · Eugene, ORBuilt 1978 · S/N 28-7816448N9226FLewis University · Romeoville, ILBuilt 1990 · S/N 4495011N9228JHail State Aviation LLC · Madison, MSBuilt 1993 · S/N 3213058
Back to AD 2008-06-28 R1