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.

N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448N415PJPalm Springs Air Museum · Palm Springs, CAS/N 0002N415PW415air LLC · Tiburon, CAS/N 4965N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041N415TLEilts Jason · Jefferson, GABuilt 2006 · S/N 2041N415VAVel-Air Inc · Clifton, VABuilt 2000 · S/N 4636290N415WBCanon Robert G · Waller, TXBuilt 2015 · S/N 4296N415WMFour Wynns Aviation Llp · Stansbury Park, UTBuilt 1999 · S/N 1005N415WRN415wr LLC · Bogart, GAS/N 4636147N415X3 Axis Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4636425N4160NSteele Howard Scott · Idaho Falls, IDBuilt 2000 · S/N 4636280N4161AKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2000 · S/N 3449160N4161PRegistered aircraftBuilt 1999 · S/N 2843309N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129N4162ZSpirit Flyers Inc · Saint Louis, MOBuilt 2000 · S/N 3257127N4163DMiraza Aviation LLC · Longview, TXBuilt 2000 · S/N 32-57145N4163EAllied Aviators Inc · Allison Park, PABuilt 2000 · S/N 3257136N4163PMalibu Aviation LLC · Bloomfield Hills, MIBuilt 2000 · S/N 4636274N4163WRedlands Flying Club · Redlands, CABuilt 1998 · S/N 2843127N41641Gunderson Roger · Fort Collins, COBuilt 1999 · S/N 2843276N4164YBoard Of Trustees · Savoy, ILBuilt 2000 · S/N 2843317N4165EJauer Brant A · Saukville, WIBuilt 1999 · S/N 2843291N4165LValiair Limited Co Trustee · Tucson, AZS/N 3257129N4165UInter American University Of Puerto Rico · Bayamon, PRBuilt 1998 · S/N 2843200N4166FStalworth Leasing Inc · Burr Ridge, ILBuilt 1999 · S/N 2843263N4166HBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843119N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138N4167KSkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843342N4167LPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2843318N4167NS&T Aviation LLC · Missoula, MTS/N 3257170N4167SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 3257153N4168DAnanas Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3449158N4168SDrew Dennis M · Danville, CABuilt 2000 · S/N 3257159N4168TTan Resources LLC · Bondurant, IABuilt 2000 · S/N 3449166N4168ZRc Aviation LLC · Grimes, IABuilt 2000 · S/N 3246169N4169TMiller Kenneth · Henderson, NVBuilt 2003 · S/N 3257313N416AMGanton Aviation LLC · Kalamazoo, MIBuilt 2005 · S/N 40.543N416CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881121N416CDLewis Jim C · Tigard, ORBuilt 2006 · S/N 1820N416CERedwing Aviation LLC · Largo, FLBuilt 2019 · S/N 4782N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124N416DSMile High Club Lc · Topeka, KSBuilt 2005 · S/N 40.533N416GWidhalm Chelsea · Yakima, WABuilt 2002 · S/N 0310N416PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843438N416PCKjt Aviation LLC · Beaumont, TXBuilt 2016 · S/N 4329N416RJCirrus Design Corp · Duluth, MNS/N 11806
Back to AD 2008-06-28 R1