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.

N2262QFirst Choice Insurance Partners LLC · Williamston, NCBuilt 1977 · S/N 28-7790387 N2264MArcher Aviation LLC · Orrtanna, PABuilt 1978 · S/N 28-7890237 N2265MEik Baaz LLC · Rocklin, CABuilt 1977 · S/N 28-7890238 N2266ZLobdell Robert T · Franklinville, NJBuilt 1979 · S/N 28-8090052 N2268MMorgan Kinder LLC · Friendswood, TXBuilt 2003 · S/N 0642 N226BBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2009 · S/N 3426 N226BCBrown John D · Parkersburg, WVBuilt 2006 · S/N 1826 N226BGMahoney Timothy P · Nantucket, MABuilt 2004 · S/N 0837 N226CDHughes William · Woodstock, ILBuilt 2001 · S/N 1130 N226CFWendler William F II · Bridgton, MEBuilt 2021 · S/N 4994 N226CHDraper Michael John · Chenoa, ILBuilt 2004 · S/N 0875 N226DFMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881535 N226DTAlpha Tango LLC · Glenn Dale, MDBuilt 1995 · S/N 3246006 N226FDBlue Mountain Aviation LLC · Newark, DEBuilt 2023 · S/N 9105 N226JHAmeritech Flight Services LLC · Hummelstown, PABuilt 2009 · S/N 3443 N226KBBex Investments LLC · Oklahoma City, OKS/N 4746 N226KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 2576 N226KTZephyr Aviation & Sales LLC · Zephyhills, FLBuilt 2021 · S/N 2781 N226LLLavezoli John Jr · Canonsburg, PABuilt 1977 · S/N 28-7716221 N226LMSun Star Aviation LLC · Oshkosh, WIBuilt 2002 · S/N 3449270 N226MKN226mk Corp Trustee · Wilmington, DEBuilt 2018 · S/N 441-0209 N226PAF & S Aviation LLC · Cary, NCBuilt 2010 · S/N 40.1087 N226PRDelozier Gerald Edward II · Vinita, OKBuilt 2026 · S/N 11246 N226RHHarding Christopher · Houston, TXBuilt 2006 · S/N 2290 N226SPHaaf Thomas P · Woodstown, NJBuilt 1978 · S/N 28-7990225 N226SRDairyaire LLC · Brookfield, WIBuilt 2023 · S/N 9179 N226STMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881570 N226TSRak Aircraft Holdings LLC · Rancho Cordova, CABuilt 2021 · S/N 2733 N226TWBb Aviation LLC · Louisville, KYBuilt 2019 · S/N 4837 N226TXGriffin Christopher W · Blowing Rock, NCBuilt 2009 · S/N 3390 N226XYTar Aviation LLC · Akron, IABuilt 2003 · S/N 0486 N226ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881609 N2272HSurric Aviation LLC · Barrington, ILBuilt 2016 · S/N 2316 N2272MGriff Air Ltd · Elk Grove, ILBuilt 1977 · S/N 28-7816269 N2272QLane Community College · Eugene, ORS/N 28-7716094 N2274LN2274l LLC · Booneville, MSBuilt 1976 · S/N LW-213 N2274QMaines Barry K · Longview, TXS/N 28-7790390 N2277CC4 Holdings Group LLC · Odessa, FLBuilt 2026 · S/N 11434 N227BDBlack Dog Aviation LLC · Avon, MNBuilt 2008 · S/N 3134 N227BWLines Merrill Alan · Mesa, AZBuilt 2007 · S/N 1770 N227DZAd Holdings Group Inc · Wilmington, DEBuilt 2008 · S/N 3288 N227EMVisceral Technologies LLC · Yulee, FLBuilt 2001 · S/N 3257208 N227FDSpettro Air LLC · Monroe, LABuilt 2023 · S/N 9113 N227HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2009 · S/N 3438 N227JHRgs Aviation LLC · Lexington, KYBuilt 2015 · S/N 4237 N227JKMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881537 N227KCSeven Kilo Charlie LLC · Lawrence, KSBuilt 2021 · S/N 5012 N227MPGo Raleigh Aviation LLC · Cary, NCBuilt 2014 · S/N 4141 N227PGDiederich Drone Service LLC · Fargo, NDBuilt 2010 · S/N 3675 N227PMEastern Stearman Inc Trustee · Leesburg, VAS/N 41750

Back to AD 2008-06-28 R1