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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N403JAEscape Aviation Leasing LLC · Overland Park, KSBuilt 2008 · S/N 411067 N403KHLaw Office Of Rick Morin Pc · Newport Beach, CAFirst renewal noticeBuilt 2008 · S/N 411116 N403MCHuntington Aviation LLC · Irving, TXBuilt 2009 · S/N 411135 N403PTProvo Cirrus LLC · Provo, UTBuilt 2007 · S/N 2404 N403ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881648 N40451Gallego Javier · Diamond Bar, CABuilt 1977 · S/N 28-7816015 N4047CInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N BB202 N404AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881813 N404BTMosaid Aviation LLC · Copperopolis, CABuilt 2024 · S/N 10258 N404CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881109 N404CCCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11571 N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819 N404JALamoreaux Gene H Trustee · Mckinney, TXBuilt 2008 · S/N 411093 N404MJParadise Boating Co · Chicago, ILBuilt 2008 · S/N 411074 N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004 N404SGColon Aviation LLC · Greenville, SCBuilt 2021 · S/N 5036 N404SHN404sh LLC · Union Gap, WABuilt 2024 · S/N 9879 N404YZMgt Aviation LLC · Minneapolis, MNBuilt 2021 · S/N 2701 N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002 N4058QPerry John S Jr · Hudson, WIS/N 28-7790469 N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738 N405AVWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2022 · S/N 8756 N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110 N405CDLbi Aviation Corp · Manahawkin, NJBuilt 2004 · S/N 0944 N405MAHigh Ways LLC · Colorado Springs, COBuilt 2005 · S/N 40.546 N405SGriffing Flying Service Inc · Port Clinton, OHBuilt 1986 · S/N 2890015 N405SBSky Bright Inc · Gilford, NHBuilt 1978 · S/N 28-7916139 N405SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2426 N405TWFlicksville Flyers Inc · Bangor, PABuilt 2008 · S/N 411105 N4060FJones Brent M · Las Vegas, NVS/N 28-7790003 N4065529 Uniform LLC · Nashville, TNBuilt 1977 · S/N 28-7890005 N40670Cavorite Aviation LLC · Lehi, UTBuilt 1977 · S/N 28-7890007 N406AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843739 N406CConstantine Jeffrey C · Charlotte, NCBuilt 2002 · S/N 0371 N406CACirro Volo LLC · Newark, DEBuilt 2026 · S/N 11200 N406CDGold Sky LLC · Albuquerque, NMBuilt 2001 · S/N 4697046 N406DRKent Keith M · Ellijay, GABuilt 1978 · S/N 28-7916072 N406FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020206 N406JRQualitair LLC Trustee · MichelstadtS/N 34-8233036 N406MACti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 2881123 N406NDUS & Global Technologies LLC · Tulsa, OKS/N 1597 N406PGShumacker James N · Carmel, INBuilt 2021 · S/N 2881449 N406SFNew Mexico State University · Las Cruces, NMBuilt 1977 · S/N LW-218 N406SRPaulus Kurt W Trustee · Delaware, OHBuilt 2006 · S/N 2298 N407AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8771 N407CDKelly George Sumner · Columbus, GABuilt 2004 · S/N 1005 N407DSStance Investments LLC · Bellefontaine, OHBuilt 2004 · S/N 40.411 N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207 N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216 N407KMGough Tecnologies Inc · Winston Salem, NCBuilt 2004 · S/N 41012

Back to AD 2008-06-28 R1