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.

N241SECarrie Chad Michael · Fort Worth, TXBuilt 2006 · S/N 3246241 N241SHSky West Aviation Inc Trustee · Albuquerque, NMS/N 0398 N241SLHickman Ira · West Richland, WABuilt 2005 · S/N 1283 N241TBSoar47llc · Charlotte, NCBuilt 2020 · S/N 4937 N241TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496559 N241TLAeronuts LLC · Santa Monica, CABuilt 2009 · S/N 3521 N241TMSoaring Cessna LLC · Brookeville, MDBuilt 2016 · S/N 4402 N241YNNechaev Yaroslav · Danvers, MABuilt 2025 · S/N 10752 N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610 N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631 N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002 N2424UOregon Air Classics LLC · Fife, WABuilt 2011 · S/N 4697459 N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N2428EHusel Robert · Bend, ORBuilt 2005 · S/N 1307 N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390 N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732 N242AZPs1two1 LLC · North Charleston, SCBuilt 2008 · S/N 3182 N242CABeaver Air LLC · Houston, TXBuilt 2024 · S/N 10206 N242CCRecreational Management Inc · Mount Ida, ARBuilt 1997 · S/N 3246095 N242DYCirrus Design Corp · Duluth, MNS/N 11742 N242GAT & T Aviation LLC · Paducah, KYBuilt 2007 · S/N 42561 N242GLPremier Real Estate Services LLC · Saint Cloud, MNBuilt 2011 · S/N 40.1125 N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277 N242MBRed Bird Aviation LLC · Waxhaw, NCBuilt 2004 · S/N 0911 N242MJWch/Lgs Sky Ventures LLC · Littleton, NCS/N 4636674 N242MLSunset Ridge Aviation LLC · Middleton, WIBuilt 2025 · S/N 10606 N242MUMarshall University · Huntington, WVBuilt 2024 · S/N 10194 N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052 N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137 N242PMPlanebiz LLC · Fort Walton Beach, FLBuilt 2008 · S/N 4692053 N242PSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 1306 N242SESanco Enterprises · Shoreview, MNBuilt 2022 · S/N 9019 N242SRVelocity Air Group LLC · Missoula, MTBuilt 2006 · S/N 2002 N242SVDudek David Michael · New Baltimore, MIBuilt 2021 · S/N 5133 N242TMCirco Industries LLC · Belle Chasse, LABuilt 2006 · S/N 2233 N242WFN242wf LLC · Wilmington, DEBuilt 2012 · S/N 4636571 N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404 N2430YBuckman Arnold H Trustee · Spring Valley, ILBuilt 1985 · S/N 32R-8513002 N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056 N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733 N243ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496042 N243CDSojourn Flight LLC · Rapid City, SDBuilt 2002 · S/N 1252 N243CHHartz C M · Key Largo, FLS/N 3369 N243DSPffc LLC · Lynden, WABuilt 2003 · S/N 40.325

Back to AD 2008-06-28 R1