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.

N662MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1262 N662NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881149 N662TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881962 N662WPHolt Gary L · Ventura, CABuilt 2000 · S/N 4636308 N663AFSnelling Peter G · Thornton, PABuilt 1981 · S/N 28-8290060 N663AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10987 N663CDCirrus Sr22 1847 Inc · Wilmington, DES/N 1847 N663KKQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3064 N663NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881288 N663WTSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843128 N66411Cirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11511 N664JHGym Cat LLC · Framingham, MABuilt 2015 · S/N 2274 N664RSMalibu Inc · Dover, DEBuilt 2000 · S/N 4636313 N664TT4mediation LLC · Lake Wales, FLBuilt 2010 · S/N 3707 N665CWAmro Air LLC · Folsom, CABuilt 2006 · S/N 2116 N665DMCyclone Aviation LLC · Macedonia, IABuilt 2008 · S/N 2975 N665MFair Haven Aviation LLC · San Francisco, CABuilt 2022 · S/N 8625 N666AJN666aj Inc Trustee · Wilmington, DEBuilt 2020 · S/N 4992 N666ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 41636 N666CDRegistered aircraftBuilt 1982 · S/N 28-8390022 N666FUTouch N Go Gnv LLC · Alachua, FLFirst renewal noticeBuilt 2006 · S/N 2264 N666KDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1892 N667AFRemontar LLC · Midland, TXBuilt 2008 · S/N 411080 N667AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10991 N667CDCirrus Aircraft Shares Inc · Williamsburg, VABuilt 2005 · S/N 1301 N667CWRegistered aircraftBuilt 2004 · S/N 1190 N667DGStone Aviation Holdings LLC · Myrtle Beach, SCBuilt 2018 · S/N 2463 N667KCPa 46 Corp · Weatherford, TXBuilt 2008 · S/N 4692067 N667LBChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843932 N667MTCassidy Transportation LLC · Macon, GAS/N 2194 N667RHN667rh LLC · Oakdale, NYBuilt 2002 · S/N 3257290 N667SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881435 N667SRN667sr LLC · Richmond, KYBuilt 2007 · S/N 2838 N668DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 40.368 N668DXCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11606 N668KCJohn A Lester LLC · Union City, TNBuilt 2006 · S/N 4697268 N668MAJohnson Saquane · Sunderland, MDBuilt 2000 · S/N 3246168 N668RSRs 238 LLC · Long Beach, NYBuilt 2024 · S/N 10268 N668SRLatitude Aviation LLC · Huntingdon Valley, PABuilt 2007 · S/N 2868 N669CDNo Fear Services LLC · Madison, WIBuilt 2022 · S/N 8921 N669DLDana Ihab A · Dalton, PAS/N 3257148 N669MAN669ma Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2620 N669PSAugust 98 Aviation LLC · Mclean, VABuilt 2006 · S/N 40.699 N66ALXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 44-7995200 N66HCNon-Stop LLC · Kirkland, WABuilt 2024 · S/N 9950 N66JEUer LLC · Searcy, ARBuilt 2025 · S/N 10592 N66JPEpic Freedom LLC · Kingsburg, CABuilt 2003 · S/N 1269 N66LGHarpenden Corp · Los Angeles, CABuilt 2011 · S/N 2843696 N66LJ66lj Flying LLC · Wilmington, DEBuilt 2003 · S/N 0727 N66NSRecker Rodney Thomas · Redding, CABuilt 2009 · S/N 411122

Back to AD 2008-06-28 R1