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.

N55DDBucks Communications Services Inc · High Point, NCBuilt 2021 · S/N 2679 N55DSN55ds LLC · Saint Paris, OHBuilt 1999 · S/N 1010 N55FAJcdc Aero LLC · Dresher, PABuilt 2024 · S/N 9886 N55GYArrokoth LLC · Virginia Beach, VABuilt 2018 · S/N 4684 N55HCMile High Club Of Texas LLC · El Paso, TXBuilt 1975 · S/N LW-134 N55JDAviation Capital Management LLC · San Jose, CAS/N 28-7790579 N55JSSky Kings 3 LLC · Irvine, CABuilt 2023 · S/N 4636821 N55KSPerlan LLC · Melbourne, FLBuilt 2003 · S/N 0550 N55LDDouble R Airways LLC · Largo, FLBuilt 1998 · S/N 3246101 N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103 N55MJBarodge Equipment Leasing Inc · Fairmount, INBuilt 1980 · S/N 32R-8013068 N55NTNew Tricks LLC · New Castle, NHBuilt 2007 · S/N 41775 N55RJAlamogordo Rental Company LLC · Alamogordo, NMBuilt 2008 · S/N 3202 N55SRGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N BB-445 N55WHSvetair Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636204 N55WTCirrus Design Corp · Duluth, MNS/N 11685 N55WVN728bj Aviation LLC · Barker, TXBuilt 2020 · S/N 4964 N55ZGDixie Painting & Sandblasting Inc · Northport, ALBuilt 2001 · S/N 4697082 N560APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843763 N560CAJace Investment Corp · Miami, FLS/N 4692113 N560CDKlohn Volker · Houston, TXBuilt 2005 · S/N 1644 N560DSBug Smasher Aviation LLC · Boston, MABuilt 2007 · S/N 40.860 N560EAEagle Aviation Columbia LLC · West Columbia, SCBuilt 2005 · S/N 1506 N560HPRjc Rental Properties LLC · San Diego, CABuilt 2001 · S/N 4697045 N560JPExecutive Aero Inc · Peyton, COBuilt 1995 · S/N 4622189 N560MPJet Prop Aviation Inc · Phoenix, AZBuilt 1998 · S/N 4636171 N560PUPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 2842098 N560SR40 And Rising Aviation LLC · Memphis, TNBuilt 2007 · S/N 2615 N5613VKempton Larry G Jr · Grand Junction, COS/N 28-7716187 N561AUIflysims Aviation Inc · Las Vegas, NVBuilt 2026 · S/N 11289 N561BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010040 N561CGreene Michael E · Auburn, ALBuilt 2002 · S/N 4636326 N561CDGainesville Aircraft Sales Inc · Gainesville, FLS/N 1640 N561CP3809 Kilo LLC · Wilmington, DEBuilt 2008 · S/N 3331 N561JTSquires Seneca LLC · Wilmington, DEBuilt 1999 · S/N 3449136 N561MAMcdonald Jeffrey D · Chilmark, MABuilt 2003 · S/N 2843561 N561MHDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 28-7690264 N561PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842103 N561RCloud 9 Aviation Holdings LLC · Boynton Beach, FLBuilt 2024 · S/N 9899 N561SSws Air LLC · Palm Beach Gardens, FLBuilt 2020 · S/N 4917 N561SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881399 N561SSEnvision Ventures LLC · Williston, NDBuilt 1979 · S/N BB-464 N561TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881861 N562AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881814 N562CDFeldman Thomas · Renton, WABuilt 2004 · S/N 1198 N562DCPresent Course Investments LLC · Coronado, CABuilt 2011 · S/N 4697473 N562FDCapital Aviation LLC · South Easton, MABuilt 2025 · S/N 10562 N562HPAir Agco LLC · Bell City, MOBuilt 2002 · S/N 4697139 N562PGQualitair LLC Trustee · MichelstadtS/N 0562 N562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 2842104

Back to AD 2008-06-28 R1