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.

N454CPWestern Chancellor LLC · Fort Worth, TXBuilt 2008 · S/N 3303 N454CWAero Investments LLC · Alabaster, ALBuilt 2013 · S/N 4692194 N454DLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020273 N454EAGeo G2 Solutions Inc · Moffett Field, CAS/N 4410054 N454KACharlie Alpha Bravo LLC · Spring Hill, KSS/N 28-7790454 N454MCGc Aviation LLC · Arden, NCBuilt 2008 · S/N 411016 N454MKSuttle Carl · San Jose, CABuilt 2004 · S/N 1447 N454RKFiore Christopher · Forked River, NJS/N 2084 N454SDDelcampo Holdings LLC · Atlanta, GABuilt 2008 · S/N 3114 N454SRFaisal Tameesh · Sterling Heights, MIBuilt 2007 · S/N 2428 N454TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020242 N454XThree Wing Flight School LLC · Stratford, CTBuilt 1978 · S/N 28-7890318 N4550DCharlymark 7 Flight Club LLC · Jamaica, NYBuilt 1983 · S/N 28-8390041 N4551FViser Timothy A · Cleveland, TNBuilt 1976 · S/N 28-7790044 N4552JAg Air Squadron One LLC · Saint Joseph, ILBuilt 1968 · S/N 28R-30413 N4554XSchwartz Michael · Bethel, CTBuilt 1975 · S/N 28-7690035 N4555Glass Bagging Ent Inc · Duncansville, PABuilt 2008 · S/N 3312 N4558JDaprile Jonathan · Port Charlotte, FLBuilt 1968 · S/N 28R-30418 N4559JBolduc Michael A · Strong, MEBuilt 1968 · S/N 28R-30419 N455AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2022 · S/N 8954 N455BDArchco II LLC · Bloomfield, NEBuilt 2004 · S/N 1029 N455BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010039 N455BZVeetwo Inc · Merritt Island, FLBuilt 1978 · S/N 3433114 N455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CABuilt 2004 · S/N 0907 N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393 N455LGBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 4697203 N455MAA & J Aviation LLC · Madison, MSBuilt 2001 · S/N 32-57205 N455MCHoffer William M · St Helena Is, SCBuilt 2009 · S/N 411148 N455MKNorth Star Aviation · Mankato, MNBuilt 2024 · S/N 4496580 N455MVGrand Sierra Investments LLC · Kingfisher, OKBuilt 2016 · S/N 4307 N455PCPch Inc · Roseville, CABuilt 2006 · S/N 1961 N455PGParker Gordon A · Afton, WYBuilt 2006 · S/N 1615 N455RSTfr Inc · Steamboat Springs, COBuilt 2005 · S/N 4697214 N455SGDdog LLC · San Angelo, TXBuilt 2001 · S/N 4697096 N455SPSrb Aviation LLC · Pewaukee, WIBuilt 2007 · S/N 2406 N455SRScottie Dog Air LLC · Wilmington, DEBuilt 2006 · S/N 2229 N455TCTompkins Landing Lc · Wayne, NEBuilt 2007 · S/N 2491 N455TWTd Air LLC · Cannon Beach, ORBuilt 2001 · S/N 4636323 N4563JPilling Ian M · Bonita, CABuilt 1968 · S/N 28R-30425 N4566JDifilippo Antonio O · Spring Church, PABuilt 1968 · S/N 28R-30429 N456ACHotel Quebec I LLC · Mount Pleasant, SCBuilt 2015 · S/N 4249 N456AKAccelerated Construction LLC · La Grande, ORBuilt 2008 · S/N 1979 N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456 N456BKSky West Aviation Inc Trustee · Albuquerque, NMS/N 4636381 N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506 N456DCCatalpa Holdings LLC · Las Vegas, NVBuilt 2005 · S/N 1525 N456EASpasco LLC · Helena, MTBuilt 1989 · S/N 4622042 N456GGCoward Lawrence Jayson · Paris, TXBuilt 2004 · S/N 0896 N456GTConquest 294 LLC · Wilmington, DEBuilt 1982 · S/N 441-0294 N456KFInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 4692021

Back to AD 2008-06-28 R1