Registered aircraft · 5,537

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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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:2012-26-15-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.

N245TTWotan America Inc · Fort Lauderdale, FLBuilt 2003 · S/N 5003 N245TXLearjet N245tx LLC · Uvalde, TXBuilt 1999 · S/N 023 N245XLSideline Inc · Tuscaloosa, ALBuilt 2018 · S/N 560-6245 N2461HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4088 N246ELTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 2224 N246FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67547 N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664 N246SJSparkjoy Air LLC · Boulder, COBuilt 2018 · S/N 1826 N247AMRegistered aircraftBuilt 2023 · S/N 2308 N247B247 Equipment LLC · Hillsboro Beach, FLBuilt 2004 · S/N 4006 N247CU283cu LLC · Gilcrest, COBuilt 2020 · S/N 2047 N247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5265 N247FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67546 N247FRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 184 N247GC10x Whirlybird LLC · Aventura, FLBuilt 2010 · S/N 41252 N247GKJoseph Equities LLC · Schiller Park, ILBuilt 2002 · S/N 193 N247JHWair Next LLC · Amelia, OHBuilt 2007 · S/N 344 N247MKOoooia LLC · Marshalltown, IABuilt 2022 · S/N 2196 N247MPRoar Aviation LLC · Bloomington, ILBuilt 2003 · S/N 5605348 N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704 N247PDDelphi Consulting LLC · Knoxville, TNBuilt 2007 · S/N 4107 N247RUAlliance Air II LLC · Burlington, NCBuilt 2017 · S/N 560-6241 N247SHUS Government · Washington, DCBuilt 2024 · S/N 2367 N248FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67545 N248LMPilatus Aircraft USA Ltd · Broomfield, COBuilt 2024 · S/N 2362 N248MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2011 · S/N 1287 N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781 N249FEFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 67544 N249GXWildcat Aviation LLC · South Salt Lake, UTBuilt 2023 · S/N 2249 N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766 N24JRWinbrook LLC · Los Angeles, CABuilt 2008 · S/N 4122 N24KSYampa LLC · Kenner, LABuilt 2007 · S/N 560-5750 N24PHExcel3 LLC · Carmel, INBuilt 2005 · S/N 560-5571 N24QSTextron Aviation Inc · Wichita, KSS/N 560-6526 N24QTQuiktrip Corp · Tulsa, OKBuilt 2024 · S/N 57512 N24XZ31dodge Air LLC · Kernersville, NCS/N 1657 N250DLHoward Flight Services LLC · Lascassas, TNBuilt 2001 · S/N 138 N250FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67543 N250KKNeed For Speed Aerospace LLC · Downers Grove, ILBuilt 2024 · S/N 2383 N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743 N250RJDixon John W · Aurora, ORBuilt 2014 · S/N 4308 N250WJEastview Av Partners I LLC · Kings Point, NYBuilt 1999 · S/N 85 N251FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67542 N251HRJohnson Breeders Inc · Rose Hill, NCBuilt 2005 · S/N 4027 N251NGJa Investments Inc · Toledo, OHBuilt 2010 · S/N 1251 N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838 N252DVG550 Aviation LLC · Grand Rapids, MIBuilt 2014 · S/N 5463 N252FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67541 N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252 N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868

Back to AD 2012-26-15 R1