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.

N2088AGary Jet Center · Gary, INBuilt 1978 · S/N 28-7916092 N2088BGeneral Aviation Support Corp · Rosamond, CABuilt 1978 · S/N 28-7916108 N2088DNationwide Aviation LLC · Hudson Oaks, TXS/N 28-7916140 N2089KBrown Frank J · Cold Spring, NYBuilt 1978 · S/N 44-7995176 N2089NSchroeder Reinhard · Poulsbo, WABuilt 1979 · S/N 28-7916255 N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89 N208CAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496161 N208CDStec Corp · Wilmington, DEBuilt 2000 · S/N 1074 N208DSMcshane Family Aviation LLC · Harrisburg, PABuilt 2005 · S/N 40.587 N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851 N208GGPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1975 · S/N 28-7690073 N208GTGti Properties LLC · Elyria, OHBuilt 2006 · S/N 1621 N208LGAnson Douglas M · Dripping Springs, TXBuilt 2005 · S/N 1566 N208THN208th LLC · Villa Rica, GAS/N 3246122 N2090VWater Sports Unlimited · Griffin, GABuilt 1979 · S/N 28-7990339 N2091BRegistered aircraftBuilt 1978 · S/N 28-7990117 N2091DRegistration Pending · Magnolia, TXRegistration pendingBuilt 1978 · S/N 28-7916141 N2091MGreat Planes Aviation Inc · Rochester, MNS/N 28-7816249 N2092AKimmons Anthony J · Quitman, TXBuilt 1978 · S/N 28-7916094 N2092MRegistration Pending · Augusta, KSRegistration pendingS/N 28-7816250 N2092XAirx LLC · Warwick, RIBuilt 1979 · S/N 28-7916342 N2093MAir Cortright LLC · Boyne City, MIBuilt 1977 · S/N 28-7890228 N2094CAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 44-7995116 N20958Ras Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7916020 N2095KCalifornia In Nice Inc · San Jose, CAS/N 44-7995180 N2096LMcfarland Bruce R · Newberry, FLBuilt 1978 · S/N 28-7916242 N2097MDm Asset Management LLC · Plain City, OHS/N 28-7890229 N2097NSidney Flying Club Inc · Sidney, OHBuilt 1979 · S/N 28-7916257 N2097UNorris Barry D · Soquel, CABuilt 1979 · S/N 28-7916311 N20985Aero X Flying Club Inc · Winchester, VAS/N 28-7990029 N2099Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020179 N20992Sketo Aviation LLC · Bardstown, KYBuilt 1978 · S/N 28-7990030 N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554 N209DSMassman Enterprises LLC · River Hills, WIBuilt 2004 · S/N 40.409 N209DWWhite Columbia Inc Trustee · Wilmington, DEBuilt 2005 · S/N 41504 N209JRegistered aircraftBuilt 1982 · S/N 28-8216153 N209JAHowen Kyle Verne · San Luis Obispo, CABuilt 2016 · S/N 4309 N209PTSilver Express DBA · Miami, FLBuilt 1979 · S/N 44-7995239 N209STSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 4697209 N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827 N20AYDmac Aircraft LLC · Savannah, GABuilt 2020 · S/N 2585 N20BKCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11527 N20CAState Of California Department Of Transportation · Sacramento, CABuilt 2019 · S/N 4844 N20CDCording Christopher Robert · Wendell, NCBuilt 1999 · S/N 1006 N20CVRoss Craig L · New Castle, DEBuilt 2005 · S/N 1532 N20EFMax Q Aviation LLC · Kalispell, MTBuilt 2021 · S/N 2700 N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032 N20HJSound Aviators LLC · Bothell, WAS/N 40.937 N20KTWatson Toby · Sheboygan, WIBuilt 2008 · S/N 4692072 N20LN303cj LLC #1 · Lexington, KYBuilt 2008 · S/N 3195

Back to AD 2008-06-28 R1