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.

N729SASierra Alpha Leasing LLC · Naples, FLFirst renewal noticeBuilt 2020 · S/N 4890N729WSGulf Sierra Partners LLC · Hilton Head Island, SCBuilt 2007 · S/N 1784N72BKUpper Airways LLC · Kalispell, MTBuilt 2002 · S/N 0172N72CBFlatland Aviation LLC · Aberdeen, SDBuilt 2014 · S/N 4697548N72DMPacific Flight Aviation LLC · Costa Mesa, CAS/N 2843471N72DVStirling Motors LLC · Kalispell, MTBuilt 2006 · S/N 2144N72ETCirrwest Ltd · Grand Junction, COBuilt 2007 · S/N 2522N72GGHall Joel · Nashville, TNBuilt 2007 · S/N 2328N72HTSan LLC · Knoxville, TNBuilt 1984 · S/N BB-1153N72JESkyward LLC · Fort Smith, ARBuilt 2005 · S/N 1654N72LLKusy LLC · New Rochelle, NYBuilt 2018 · S/N 4633N72MJValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10652N72MMCirrus 20 LLC · Gainesville, FLBuilt 2026 · S/N 11323N72MZUtah State University · Logan, UTS/N 40.716N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891N72VUVincennes University · Vincennes, INBuilt 2026 · S/N 11197N72WYBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 4697322N730AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843792N730CN730c LLC · Merrimack, NHS/N 0410N730CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881736N730CBHawk Fly LLC · Lamesa, TXBuilt 1997 · S/N 34-49030N730CDCirrus Associates LLC · Colorado Springs, COS/N 0053N730DSFoerster James · Carmichael, CABuilt 2007 · S/N 40.737N730HBBaggett David · Coppell, TXBuilt 2006 · S/N 1617N730LKBay Aero Ventures LLC · Port Clinton, OHBuilt 1977 · S/N 28-7890070N730MABennett Robert · Lutz, FLBuilt 2024 · S/N 2881697N730NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843887N730SASun Aircraft Management LLC · Ormond Beach, FLBuilt 2010 · S/N 2842363N730UOhio University · Albany, OHBuilt 2005 · S/N 2842224N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066N7311KChunga Air LLC · Orange Park, FLBuilt 2014 · S/N 4125N731ACAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881495N731APEastway Properties LLC · Moxee, WABuilt 2009 · S/N 3566N731ATMark L Carman · Aiken, SCBuilt 2005 · S/N 1728N731BRPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4697731N731CDOwen Brian F · Tulsa, OKBuilt 2001 · S/N 0129N731EAExperience Aviation Inc · Opa Locka, FLBuilt 2005 · S/N 41518N731JBLea Kenneth R Trustee · St Charles, ILS/N 4697343N731JHGcl Juliet Hotel LLC · Winter Springs, FLBuilt 2021 · S/N 5027N731NDAir Shares LLC · Casper, WYBuilt 2016 · S/N 2843855N731PAMathis John G · South Bend, INBuilt 2006 · S/N 40.731N731PPPoli Poli Inc · Sausalito, CABuilt 2012 · S/N 3829N731VCCuster Joseph A Jr · League City, TXBuilt 2023 · S/N 9529N731VGCoastal Meridian LLC · El Segundo, CAFirst renewal noticeBuilt 2007 · S/N 4697326N731WF29 Aviation LLC · Granite Falls, MNBuilt 2016 · S/N 4421N731WMBoard Of Trustees Of Western Michigan University · Kalamazoo, MIBuilt 2024 · S/N 9958N7329YAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2004 · S/N 1394N732ABJohn L Dolan Consulting LLC · Vienna, VABuilt 2018 · S/N 4615N732CDK9 Aviation LLC · Tyler, TXBuilt 2005 · S/N 1685N732DSCarroll Ian · Washington, DCBuilt 2006 · S/N 40.732
Back to AD 2008-06-28 R1