Registered aircraft · 16,290

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.

N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016 N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237 N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597 N102DWFlyboy Aviation LLC · Memphis, TNBuilt 2006 · S/N 1750 N102FPN9817k LLC · Fredericksburg, VABuilt 2006 · S/N 42511 N102GGVictor Airways LLC · Canton, GABuilt 2021 · S/N 2730 N102JSRegistration Pending · Cresco, PARegistration pendingBuilt 2024 · S/N 9919 N102KWVentura Douglas · Cambridge, MDBuilt 2003 · S/N 0755 N102LTSandjuice LLC · Gainesville, FLBuilt 2002 · S/N 0288 N102PBDeland Air And Sea Brokerage Inc · Deland, FLS/N 0321 N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042 N102SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1864 N102UVFrequency Change Aviation Services Inc · Nashville, TNBuilt 2005 · S/N 40.549 N102VAVectored Aircraft Leasing LLC · Austin, TXBuilt 2025 · S/N 10511 N1030NDcaw Aviation LLC · Advance, NCBuilt 2006 · S/N 3246242 N1032GOsgood Air LLC · Hays, KSBuilt 2006 · S/N 4697285 N1032HPanhandle Air LLC · Destin, FLBuilt 2007 · S/N 4697302 N10332Tx Holdings · Hermosa Beach, CABuilt 2009 · S/N 411132 N1036PHeyden Aviation LLC · Alpharetta, GABuilt 2009 · S/N 411138 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103CClarity Its LLC · Canton, GABuilt 2002 · S/N 0432 N103EECirrus Djh LLC · Bountiful, UTBuilt 2006 · S/N 2104 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N103ERR & J Aviation LLC · Bloomfield Hills, MIBuilt 2016 · S/N 2321 N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838 N103FPStyle Ventures LLC · Lafayette, LABuilt 2006 · S/N 42512 N103MK2141 Corp · Wilmington, DEBuilt 2005 · S/N 1444 N103PFQuality Protection Inc · Springfield, MOBuilt 2008 · S/N 411092 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N103UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.683 N103VAA-Team Aviation LLC · Austin, TXBuilt 2025 · S/N 10788 N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104BZSterling Aviation LLC · Newport Beach, CABuilt 2004 · S/N 1219 N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999 N104ETLmc Angels LLC · Hinckley, OHBuilt 2004 · S/N 1024 N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292 N104FPAutowashlbt LLC · Lumberton, NCBuilt 2006 · S/N 42513 N104GHBluff Point Aviation LLC · Jensen Beach, FLBuilt 2014 · S/N 4087 N104JASkywest Leasing Inc · Saint George, UTBuilt 2004 · S/N 40.440 N104KVKatiegirl Aviation LLC · Stockton, CABuilt 2021 · S/N 2683 N104PPToledo Public Schools · Swanton, OHS/N 41086 N104TQGtw Aviation LLC · San Jose, CABuilt 2006 · S/N 2304 N104UVUtah Valley University · Orem, UTBuilt 2006 · S/N 40.684 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N104WHGreycal Enteprrises Inc · Lake Mary, FLBuilt 2005 · S/N 3232046

Back to AD 2008-06-28 R1