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.

N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021 N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022 N237CLnh Holdings LLC · Richardson, TXBuilt 2013 · S/N 4636610 N237CGSonoma Valley LLC · Missoula, MTBuilt 2008 · S/N 2934 N237DSYoung Mark K · Charleston, WVBuilt 2005 · S/N 40.592 N237DYCirrus Design Corp · Duluth, MNS/N 11715 N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015 N237JMBrekke Aviation Inc · Edmore, NDBuilt 2001 · S/N 4697078 N237MAR E Dimond And Associates Inc · Indianapolis, INBuilt 2013 · S/N 4636587 N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815 N237MTPiper Aircraft Inc · Vero Beach, FLS/N 4496660 N237RJArgaeus LLC · Poway, CABuilt 2006 · S/N 2159 N237STIlluminus Aviation LLC · Chicago, ILBuilt 2005 · S/N 4697237 N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249 N238ARN238ar LLC · Hickory, NCBuilt 2002 · S/N 0346 N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037 N238CARegistered aircraftBuilt 2011 · S/N 3789 N238CDHerega Mark Allen Sr · Brick, NJBuilt 2002 · S/N 0359 N238DCKick Tires Light Fires LLC · Seattle, WABuilt 2008 · S/N 40.967 N238DYCirrus Design Corp · Duluth, MNS/N 11716 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238JGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2476 N238MCBrotherton Douglas E Trustee · Dubuque, IABuilt 1993 · S/N 3213047 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238MUMarshall University · Huntington, WVBuilt 2023 · S/N 9590 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238RSPeace Transportation LLC · Harrison, TNBuilt 2019 · S/N 4862 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N2391QNew Hamphire Flyers LLC · Lyme, NHBuilt 1977 · S/N 28-7790395 N2392QTwin Eagle Flying Club Inc · Pikeville, KYBuilt 1977 · S/N 28-7790396 N2395VConfluence Systems Consulting Inc · San Jose, CAS/N 28-8590069 N239APMbn2fly LLC · Laurel, MSBuilt 2022 · S/N 8616 N239ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496038 N239BCPhillips John S · Bristol, RIBuilt 2006 · S/N 41621 N239CWolvestown LLC · Humble, TXBuilt 2003 · S/N 2843581 N239DCUtah State University · Logan, UTBuilt 2008 · S/N 40.968 N239DSEmley Tyler E · Hebron, INBuilt 2007 · S/N 40.831 N239DYCirrus Design Corp · Duluth, MNS/N 11733 N239JNargis Aviation LLC · Fairfield, NJBuilt 2019 · S/N 2468 N239JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020009 N239MAHeath Robert D · Locust Grove, GABuilt 2005 · S/N 40.512 N239MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881868 N239NDPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842100 N239REAvesta Logistics LLC · Naples, FLBuilt 2025 · S/N 10725 N239RFCirrus Design Corp · Duluth, MNS/N 11750 N239STN239st LLC · Peachtree City, GABuilt 2006 · S/N 3246239 N23ABCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11534 N23AJArcadia Aviation LLC · Milton, MABuilt 2018 · S/N 4650 N23ALPv Aviation LLC · Poland, OHBuilt 1981 · S/N 32R-8213008 N23AUAverett University · Danville, VABuilt 2024 · S/N 4496570

Back to AD 2008-06-28 R1