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.

N227PQMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881544 N227RCRomeo Kilo Aircraft Holdings LLC · West Sacramento, CABuilt 2024 · S/N 9920 N227RTBarnard David W · La Follette, TNBuilt 2007 · S/N 2357 N227SMIpme Management Corp · Jefferson, GABuilt 2004 · S/N 41011 N227SPIowa State Patrol · Des Moines, IABuilt 2021 · S/N 5050 N227WBSlamo LLC · Bulverde, TXBuilt 2017 · S/N 4523 N227WDPowell David C · Ingram, TXBuilt 1990 · S/N 4622097 N227XYMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881571 N2280QJaz One Holdings Inc · Farmingdale, NYS/N 28-7716095 N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096 N2283QPearl Aviation Inc · Appleton, WIS/N 28-7790391 N2284QZm Farms Lllp · Horace, NDS/N 28-7790392 N2286MRegan Herbert George · Gowen, MIBuilt 1977 · S/N 28-7816271 N2287AGiacopassi Dean · Newport News, VABuilt 2002 · S/N 40.226 N2288DTen Equipment LLC · Boston, MABuilt 2011 · S/N 3761 N2288YHarens Jason · Maple Grove, MNS/N 1218 N2289MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816274 N228AMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 28-7990544 N228CFAsterix Aviation Inc · New York, NYBuilt 2021 · S/N 5007 N228FD228 Properties LLC · Tabernacle, NJBuilt 2023 · S/N 9115 N228GGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 28-7990387 N228KHSkyceci LLC · Comelius, NCBuilt 2022 · S/N 2881521 N228LGSs228lg LLC · Middle River, MDBuilt 2007 · S/N 1780 N228MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881985 N228MMFly Enterprises LLC · Cumberland, WIBuilt 2005 · S/N 1335 N228QRMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881538 N228RMitchell Warren A · Deatsville, ALBuilt 1982 · S/N 34-8233145 N228TRDap Holdings LLC · Danbury, CTBuilt 2005 · S/N 1511 N228UVMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881568 N228WCYard Bird Aviation LLC · Key West, FLBuilt 1983 · S/N 28-8416023 N2291HCommand Aviation · Bellingham, WABuilt 1978 · S/N 28-7816176 N2293QBuitron Quispe De Hamilton Monica · Lockhart, TXS/N 28-7716099 N2296ZPrevost Dustin · Alpena, MIBuilt 1978 · S/N 28-7816116 N229ABMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881539 N229BParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020204 N229CDGurley Eric · Omaha, NEBuilt 2001 · S/N 1131 N229DATyler Aviation Holdings LLC · Birmingham, ALBuilt 2017 · S/N 2341 N229DMWisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 28-7890246 N229DTEyes In The Skies LLC · Oklahoma City, OKBuilt 2012 · S/N 3850 N229FSmith Dennis L · Burbank, CABuilt 2006 · S/N 2299 N229FGFlightgest Academy LLC · Morrisville, NCBuilt 2021 · S/N 28020020 N229JK2 Aviation LLC · Greenwood Village, COBuilt 2018 · S/N 2436 N229LMMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881572 N229MAN&D Executive Services LLC · San Antonio, TXS/N 4636129 N229MMFair Winds Aviation LLC · Cheyenne, WYBuilt 2008 · S/N 4692029 N229NDAri Ben Aviator Inc · Fort Pierce, FLBuilt 2001 · S/N 2842113 N229RMMjt Real Estate Holdings LLC · Orlando, FLBuilt 2002 · S/N 0416 N229SG229sc LLC · Fayetteville, GABuilt 2006 · S/N 1956 N22ADMorganav Inc · Chapel Hill, NCBuilt 2018 · S/N 4641 N22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176

Back to AD 2008-06-28 R1