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.

N778PZG3 Aviation LLC · Cranston, RIBuilt 2023 · S/N 9463 N7793CPaolucci James H · Warwick, RIBuilt 1975 · S/N 28-7690082 N7797SBaker Brian · Stanton, TXBuilt 2003 · S/N 0765 N779COweis Yaseen · Bellaire, TXBuilt 2003 · S/N 0444 N779CCRyan Robert M · Anaheim, CABuilt 1980 · S/N 4410155 N779CDHiatt John Trustee · West Des Moines, IABuilt 2004 · S/N 1445 N779GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881222 N779JWFaero LLC · Bakersfield, CABuilt 2019 · S/N 4797 N779TWClassic Flyers LLC · Indianapolis, INBuilt 2008 · S/N 3261 N779USUtah Valley University · Orem, UTBuilt 2007 · S/N 40.779 N779WCLane William Michael · Green Bay, WIBuilt 2004 · S/N 1247 N77BTWings Up LLC · Kansas City, MOBuilt 2014 · S/N 4697554 N77CA77ca Associates LLC · Coral Gables, FLBuilt 1980 · S/N BB-717 N77CESmall Plane LLC · Carson City, NVBuilt 1978 · S/N LW-257 N77CXAces High Aviation LLC · Tulsa, OKBuilt 2014 · S/N 4051 N77DRGeodetic Associates International LLC · Pittstown, NJBuilt 1995 · S/N 3246005 N77DUChaffee Merilyn D · Angwin, CABuilt 1999 · S/N 3257101 N77EQDuncan Real Estate Investments LLC · Sutherlin, ORS/N 287790101 N77FTCapeplane LLC · Cape May, NJBuilt 1997 · S/N 3449018 N77GMMartin Gustavo E · Cooper City, FLBuilt 1976 · S/N 28-7790218 N77KPInformation Softworks Inc · Ann Arbor, MIBuilt 1981 · S/N 34-8133067 N77PKMagic Carpet Ride LLC · Burlington, IAS/N 4622089 N77TPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 4636575 N77VFOrions Victor Foxtrot LLC · Truckee, CABuilt 2009 · S/N 4697408 N77WFKt Aviation LLC · Las Cruces, NMBuilt 1972 · S/N LW-4 N77YYN77yy Corp Trustee · Wilmington, DEBuilt 1999 · S/N 32-57120 N77ZBIkiugu Moses · Vermillion, SDS/N 28-7790359 N77ZXSaline County Cirrus LLC · Benton, ARBuilt 2003 · S/N 1299 N780CDGreene James W · League City, TXBuilt 2004 · S/N 1202 N780LAN780la LLC · Philadelphia, PABuilt 2025 · S/N 28020222 N780NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496502 N780UOhio University · Albany, OHBuilt 2005 · S/N 2842232 N780ZCornerstone Aviation LLC · Columbus, INBuilt 2005 · S/N 3232043 N7815FBrammer Bryon L · Simi Valley, CABuilt 1976 · S/N 28-7790226 N7818MFlynn Bec Gp Inc · Spokane, WABuilt 2015 · S/N 4697582 N781CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1423 N781LAN781la LLC · Philadelphia, PABuilt 2025 · S/N 28020213 N781LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496369 N781NDRainier Flight Service LLC · Renton, WABuilt 2016 · S/N 4496395 N781PAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010042 N781PWPf Flyers Inc · Lavonia, GABuilt 2025 · S/N 10576 N781SRRegistration Pending · Scottsdale, AZRegistration pendingBuilt 2008 · S/N 3310 N7820CSummit Flight Academy LLC · Peculiar, MOBuilt 1975 · S/N 28-7690083 N7821CArmy Knife Enterprises LLC · Oak Hills, CABuilt 1975 · S/N 28-7690084 N7822MAero Rocket LLC · Las Vegas, NVBuilt 2005 · S/N 1722 N782CDArbuckle Roger · Greenville, KYBuilt 2005 · S/N 1691 N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464 N782JRCirrusly Aviation - A Family Affair J2911 LLC · Duson, LABuilt 2016 · S/N 2337 N782KJSrl Investments LLC · Boone, IABuilt 2005 · S/N 42083 N782LAN782la LLC · Philadelphia, PABuilt 2025 · S/N 28020214

Back to AD 2008-06-28 R1