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.

N23BCJp Saul Medical Flight Services Consulting LLC · Mount Pleasant, SCBuilt 2009 · S/N 3514 N23CMTreasury Ventures LLC · Mountain View, CABuilt 2018 · S/N 2466 N23DDK Tahoe Air LLC · Glendale, CABuilt 2023 · S/N 2881676 N23DKStockwell Aviation LLC · Clarence Center, NYBuilt 2018 · S/N 4636721 N23HCMcbride Gary · Englewood, FLBuilt 2021 · S/N 5032 N23KPSp Aviation Inc · Hayward, CABuilt 2004 · S/N 41004 N23LWGateway Air Center Inc · Merced, CABuilt 2005 · S/N 1450 N23NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7716036 N23NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0066 N23STGreensky Aviation LLC · Mountain Home, ARBuilt 1978 · S/N BB-375 N23SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2366 N23WHM Hixson Aviation LLC · Lake Dallas, TXBuilt 2026 · S/N 11356 N23XUTwo Three Xray Uniform LLC · Overland Park, KSBuilt 2022 · S/N 8633 N24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEBuilt 2010 · S/N 4496290 N2406PAam Aeromed LLC · Wilmington, DEBuilt 2011 · S/N 4697448 N240AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881731 N240AFColumbia Av8ors Inc · Dover, DEBuilt 2005 · S/N 41525 N240AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496650 N240CAN240ca LLC · Wilmington, DEBuilt 2010 · S/N 411159 N240DYCirrus Design Corp · Duluth, MNS/N 11740 N240ERAlexander Aviation LLC · Scottsdale, AZBuilt 2011 · S/N 4697447 N240JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020010 N240MBFlying Brick LLC · Monroe, NCBuilt 2006 · S/N 1880 N240RWestex Telco LLC · Abilene, TXS/N 3449496 N240SPValiair Limited Company Trustee · Casper, WYBuilt 2026 · S/N 11613 N240SRMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N 2411 N240TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496558 N240UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020161 N240WARight Traffic LLC · Ellenton, FLBuilt 2013 · S/N 3940 N24139Averett University · Danville, VABuilt 2011 · S/N 2843697 N2413ACotner Jeffry J · Houston, TXBuilt 2011 · S/N 4636496 N24177Fever Five LLC · Salem, ORBuilt 2011 · S/N 4692167 N2418NDah Aviation LLC · Boerne, TXBuilt 2022 · S/N 8953 N2418WSierra Tango Air LLC · Sycamore, ILBuilt 2011 · S/N 4697464 N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039 N241BSAdventure Airways LLC · Sacramento, CABuilt 2008 · S/N 421014 N241CMFalgout Scott · La Place, LABuilt 2002 · S/N 0357 N241CPAdvanced Aircraft Sales LLC · Miami, FLBuilt 2006 · S/N 1713 N241DGJust Plane Fun · Santa Barbara, CABuilt 2010 · S/N 4636489 N241DYCirrus Design Corp · Duluth, MNS/N 11741 N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065 N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023 N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011 N241LCD&D Air Services LLC · Mooresville, NCBuilt 2018 · S/N 4731 N241LLManuel Hector · The Woodlands, TXBuilt 2021 · S/N 2752 N241MBFlying Brick LLC · Monroe, NCBuilt 2004 · S/N 0910 N241MUMarshall University · Huntington, WVBuilt 2024 · S/N 10052 N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051 N241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 0102 N241PMBryants Aviation Inc · Batesville, ARBuilt 2003 · S/N 4697150

Back to AD 2008-06-28 R1