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.

N497AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9413N497BCBarnes William · Hagerstown, MDBuilt 2010 · S/N 411157N497CPGulfstream Turbine LLC · Naples, FLBuilt 2008 · S/N 3315N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075N497MAAlexandria Spine & Rehab Center LLC · Alexandria, LAS/N 4636498N497MSN497ms LLC · Miami, FLBuilt 2015 · S/N 4636678N497PGHlc Aviation LLC · Litchfield Park, AZS/N 1973N497TZLightspeed Aviation LLC · Lutz, FLBuilt 2022 · S/N 8773N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229N4984JBluewater Airmotive Corp · Wilmington, DEBuilt 1968 · S/N 28R-30738N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740N4987JFulco Jason E · Frisco, TXS/N 28R-30742N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744N498AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9417N498BCOutside In Aviation LLC · Fort Madison, IABuilt 2015 · S/N 4268N498CDCrew Zen Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 1549N498DDCambridge Industries LLC · Rehoboth, MABuilt 2020 · S/N 4910N498GNChb Aw LLC · Amarillo, TXBuilt 2007 · S/N 2587N498HPSafe Flight Ops LLC · Venetia, PABuilt 1998 · S/N 3246121N498MALake Air Express LLC · Bettendorf, IABuilt 1998 · S/N 3246098N498MMLadd Air LLC · Mt Holly, NCS/N 4636149N498RDJacobsen Aviation LLC · Avoca, IABuilt 2006 · S/N 41685N498SGQualitair LLC Trustee · MichelstadtBuilt 2006 · S/N 40.706N498SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2006 · S/N 2081N498TTMiddletown Composites Inc · Berea, KYBuilt 2015 · S/N 4239N4990JEstes Aviation LLC · Vicksburg, MSBuilt 1968 · S/N 28R-30746N4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842230N4992JBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 28R-30748N4994JCrowe Justin L · Tompkinsville, KYS/N 28R-30750N4996JLee Matthew · Magnolia, TXBuilt 1968 · S/N 28R-30752N499RARenegade6 Aviation LLC · Woodbridge, VABuilt 2008 · S/N 411042N499RJNd-Pace Logistics LLC · Sneads Ferry, NCBuilt 2009 · S/N 3588N499UVUtah Valley University · Orem, UTBuilt 2019 · S/N 4496454N499VAIdeker Inc · Saint Joseph, MOBuilt 2006 · S/N 1921N499WLee Chris · Granger, INBuilt 2004 · S/N 40.423N49BTFlight Levels LLC · Ridgeland, MSBuilt 2003 · S/N 4697161N49CEIttf LLC · Fort Lauderdale, FLBuilt 2017 · S/N 4504N49DACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11555N49EDOak Country Air LLC · Laguna Beach, CABuilt 2016 · S/N 4388N49ER49air LLC · San Rafael, CABuilt 2024 · S/N 10013N49KCBeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB-318N49LLSilver Wing Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB-843N49PKMalibu Associates Inc · Frederick, MDBuilt 1989 · S/N 4622050N49PTWright Wrench Aviation LLC · Cedar City, UTBuilt 1997 · S/N 2843094N49PXN49px Group LLC · West Jordan, UTBuilt 2009 · S/N 3570N49TBMitchell Derrick M · Houston, TXBuilt 2004 · S/N 1466N49WFTech Air Systems LLC · Apollo Beach, FLBuilt 2007 · S/N 2610
Back to AD 2008-06-28 R1