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.

N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038 N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047 N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042 N2576XOchoa Chase E · Williamsburg, VABuilt 1985 · S/N 32R-8513013 N2578BPope Golf LLC · Sarasota, FLBuilt 2001 · S/N 1145 N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071 N257CDPahlavan Benham A · Santa Rosa, CABuilt 2002 · S/N 1184 N257CTLane Community College · Eugene, ORBuilt 1978 · S/N 287816053 N257DSGlazier Enterprises LLC · Reno, NVBuilt 2003 · S/N 40.265 N257FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020057 N257FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10063 N257LGClear Sky Aviation LLC · Coral Springs, FLS/N 46-36066 N257MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881450 N257SRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2006 · S/N 2132 N257TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881857 N257TLTornado Alley Turbo Inc · Ada, OKBuilt 2012 · S/N 2165 N257ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881612 N2586XPiper Kffc LLC · Peachtree City, GABuilt 1985 · S/N 28-8690003 N258CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881356 N258CDWyman Michael J · Greenville, SCBuilt 2002 · S/N 1186 N258CPAll Furniture Services LLC · Cliffside Park, NJBuilt 2006 · S/N 1744 N258CWKpj Aviation LLC · West Palm Beach, FLBuilt 2024 · S/N 10107 N258DSCooper James K II · Madisonville, KYBuilt 2008 · S/N 40.1016 N258JSNational Biomechanics Institute LLC · Santa Monica, CABuilt 2015 · S/N 2275 N258KJBcr Investments LLC · Wilmington, DEBuilt 2018 · S/N 4628 N258MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881451 N258RMNighthawk N8231g LLC · Pompano Beach, FLS/N 44-8107029 N258STPanchjanyam LLC · Jackson, MSBuilt 2002 · S/N 0307 N258WTTrigger Air LLC · Wilmington, DEBuilt 2014 · S/N 4152 N25906Valiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4636590 N2590UBlue & Gold LLC · South Boston, VABuilt 2013 · S/N 4697514 N2591BDevries Larry E · Pella, IABuilt 2013 · S/N 4636583 N2592YValiair Lc Trustee · Casper, WYBuilt 2013 · S/N 4636592 N259ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496080 N259CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881004 N259CDGo Air Brokerage LLC · Wake Forest, NCBuilt 2003 · S/N 0449 N259GCotton Tail Transportation LLC · Singer Island, FLBuilt 1975 · S/N BB-62 N259MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881452 N259PBOregon Holdings LLC · Bend, ORBuilt 2001 · S/N 0111 N259PEParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716226 N259SCCei Inc · Wilmington, DES/N LW17 N259SRJu87 LLC · Hudson, MABuilt 2006 · S/N 1749 N25ADPaxton Homes LLC · Killeen, TXBuilt 1983 · S/N 348333001 N25AVAvalon Aviation LLC · Kennett Square, PABuilt 2020 · S/N 4966 N25BZBarbara Jean Ventures LLC · Winnsboro, SCBuilt 2021 · S/N 5103 N25CAWhite Dog Aviation LLC · Portola Valley, CABuilt 2006 · S/N 3257424 N25DDCirrus Air LLC · Sparks, NVBuilt 2004 · S/N 0894 N25DZCigar Army One Inc · Tampa, FLBuilt 2006 · S/N 1783 N25EVPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 2881866 N25HGFiggins Darrin W · Ulysses, KSS/N 28-7890206

Back to AD 2008-06-28 R1