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.

N555RUHands Holding · Newark, DEBuilt 1981 · S/N 32R-8129114 N555SBAvia Blue LLC · Emerald Hills, CABuilt 2019 · S/N 4765 N555TLTta Holdings LLC · Dublin, GABuilt 2020 · S/N 4970 N555TPNugget Investments LLC · Strongsville, OHBuilt 1979 · S/N 32R-8029041 N555UJAero Holdings LLC · Palm City, FLBuilt 1984 · S/N 348433039 N555VAEscape Velocity LLC · Driggs, IDBuilt 2004 · S/N 41033 N555VGCordingley Robert · Lafayette, COBuilt 2010 · S/N 3701 N555ZGJeminn LLC · Scottsdale, AZBuilt 2004 · S/N 1116 N5567JVision Aeronautics LLC · Dequincy, LABuilt 2016 · S/N 4424 N556BATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4697404 N556CDSec Ventures LLC · St Charles, ILBuilt 2004 · S/N 1033 N556CESt Patrick Reserves LLC · St Louis, MOBuilt 2010 · S/N 3653 N556GGCapital Group Logistics LLC · Tallahassee, FLBuilt 2024 · S/N 10139 N556LInternational Air Services Inc Trustee · Carson City, NVS/N 0132 N556LUOriens Flight LLC · Windsor, CABuilt 2007 · S/N 40.763 N556PCChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496074 N556PLSerenity Skies LLC · West Chester, PABuilt 2023 · S/N 9388 N556SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881343 N556SROhaver Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2856 N557AFWateractive43 LLC · Auburn, CABuilt 2009 · S/N 40.1057 N557CACci Air LLC · Dell Rapids, SDBuilt 2005 · S/N 1594 N557CCRedhawk Aviation LLC · Mccomb, MSBuilt 2023 · S/N 9557 N557DSIn Flight Aircraft LLC · Howell, MIBuilt 2004 · S/N 40.357 N557DTRedace LLC · New York, NYBuilt 1985 · S/N 28-8690022 N557JPLuxury Air Tours Of South Florida LLC · Fort Lauderdale, FLS/N 40.259 N557MLAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 4636064 N557PSSchoen Jeffrey · Brentwood, TNBuilt 2007 · S/N 40.757 N557PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842094 N5586DOh Joseph K · Anaheim, CABuilt 1967 · S/N 28R-30116 N5586VFisher Robert W · Katy, TXS/N 28-7716183 N5587VNorth Country Aviation LLC · Kalispell, MTS/N 28-7716184 N5589VKempton Larry G Jr DBA · Grand Junction, COS/N 28-7716185 N558ATSkywalker Aviation LLC · Jacksonville, FLBuilt 2020 · S/N 4915 N558CDSr Global Partners LLC · Laguna Beach, CABuilt 2005 · S/N 1414 N558JTR2jm Leasing LLC · West Bloomfield, MIBuilt 2008 · S/N 4692051 N558KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843879 N558MCTransigent Air LLC · Seneca, PABuilt 2005 · S/N 0006 N558PGConverting Solutions Inc · Maiden, NCBuilt 2008 · S/N 3024 N558SRAllenergy Aircraft LLC · Trego, WIBuilt 2006 · S/N 2193 N558STNewport Federal · Newport Beach, CABuilt 2012 · S/N 4636558 N558SWProtec Proz LLC · Ball Ground, GABuilt 2005 · S/N 1504 N5592VBlack Dog Air LLC · Satellite Beach, FLBuilt 1977 · S/N 28-7790482 N559ACRebel Air LLC · Oxford, MSBuilt 2006 · S/N 1927 N559CInternational Air Services Inc Trustee · Carson City, NVS/N 3449238 N559DSMaverick Air Group LLC · Los Angeles, CABuilt 2001 · S/N 40059 N559MANorwood Kenneth Trustee · Rogers, ARBuilt 2000 · S/N 3246159 N559MMScience Brew LLC · Kenosha, WIBuilt 2002 · S/N 0349 N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096 N559SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 2875 N55CTFly 55 LLC · Winter Springs, FLBuilt 2023 · S/N 9193

Back to AD 2008-06-28 R1