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.

N25386Fairview Farms Inc · Poteau, OKBuilt 1985 · S/N 28-8590088 N2538MWarren James Rent · Rapid City, SDBuilt 2005 · S/N 41081 N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078 N2539XWhy Drive LLC · Houston, TXBuilt 2006 · S/N 42505 N253ATAirlines Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496057 N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448 N253DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010034 N253ESchnack Aviation LLC · Twin Falls, IDBuilt 2008 · S/N 3106 N253FDMile High Aviation LLC · Farmingdale, NJBuilt 2024 · S/N 9845 N253HLIscil Kaan · Miami, FLBuilt 2021 · S/N 4636779 N253JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020034 N253JSN253js LLC · Wilmington, DEBuilt 2017 · S/N 4566 N253MAHoosier Doc LLC · South Bend, INFirst renewal noticeBuilt 2004 · S/N 4636353 N253MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881445 N253SBN253sb Shares LLC · Liberal, KSS/N 4410258 N253SRDara Mortgage Inc · Las Vegas, NVBuilt 2006 · S/N 2034 N253WCba Investments LLC · Kalispell, MTBuilt 2004 · S/N 0881 N2540MGlobal Emergency Services LLC · Beaumont, TXS/N 41031 N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404 N2541AEnergy307 LLC · Casper, WYBuilt 2005 · S/N 41085 N2541MWard Gregory D · Philadelphia, MSBuilt 2004 · S/N 41028 N2542TCavu Aviation LLC · Searcy, ARBuilt 2005 · S/N 41508 N2542WYoder Enos D · Goshen, INBuilt 1985 · S/N 32R-8613001 N2543URegistered aircraftBuilt 1979 · S/N 28-8090055 N2544TSpindler Construction Corp · Logan, UTBuilt 2005 · S/N 41072 N2544WJoseph Belew · Clarksville, TNBuilt 2005 · S/N 41530 N2545BD & H Equities LLC · Helena, MTBuilt 2004 · S/N 41036 N2545CDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496324 N2545HNoble Aviation Enterprises LLC · Phoenix, AZBuilt 2012 · S/N 4636561 N2545KToscano Holdings · Eads, TNBuilt 2004 · S/N 41039 N2545TTrautman Bruce D · Minneapolis, MNBuilt 2005 · S/N 41080 N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032 N25460Kleen Sheen IV LLC · Bowling Green, KYBuilt 1985 · S/N 34-8533041 N2546UL00 Fliers LLC · Lewes, DEBuilt 1979 · S/N 28-8016033 N2547TBuilding Eleven Ventures LLC · West Chester, OHBuilt 2006 · S/N 42503 N2547YWayjo Inc · Tampa, FLBuilt 1985 · S/N 32R-8529018 N2548QChristian Keith · Lighthouse Point, FLS/N 28-7716110 N2549DLkd & Associates Inc · Monroe, GAS/N 4692178 N2549QFly Legacy Planes LLC · Philadelphia, PABuilt 1977 · S/N 28-7716111 N2549WStr Aviation LLC · Burlington, IABuilt 2007 · S/N 2549 N254AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881754 N254ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496062 N254CCSouth Ga Flyers LLC · Valdosta, GABuilt 2007 · S/N 2902 N254CDMaw Energy LLC · Hagerman, NMBuilt 2002 · S/N 1166 N254DBBurns Darryl E · Salinas, CABuilt 2002 · S/N 0157 N254DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010035 N254FDVista Air LLC · Boxborough, MABuilt 2024 · S/N 9847 N254HTFly254 LLC · Waco, TXBuilt 1993 · S/N 4622127 N254JAAlpha Aviation LLC · Indianapolis, INBuilt 2021 · S/N 28020035 N254KPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496652

Back to AD 2008-06-28 R1