Registered aircraft · 432

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:2005-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-24-13') 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:2005-24-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-24-13')
  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:2005-24-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-24-13')
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.

N918LSSamson Energy Company LLC · Tulsa, OKBuilt 2016 · S/N 547 N918PTTennthom Aviation Corp · La Vergne, TNBuilt 2016 · S/N 542 N91SURegistered aircraftBuilt 2015 · S/N 528 N925JBJb Aviation LLC · Park City, UTBuilt 2004 · S/N 251 N927SKCrosley Aviation LLC · Warsaw, INBuilt 1999 · S/N 051 N930CC4 Eagles LLC · Tampa, FLBuilt 2007 · S/N 2078 N935RKKing Air LLC · Oak Brook, ILBuilt 2007 · S/N 318 N942FKForty Er LLC · Bethany, OKBuilt 2001 · S/N 145 N945EJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 2108 N945HCFloundering Four LLC · Anchorage, AKBuilt 2000 · S/N 109 N946RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 575 N94CKConsolidated Pipe & Supply Co Inc · Birmingham, ALBuilt 2010 · S/N 410 N959RPOrlando Plane Partners LLC · Orlando, FLBuilt 2013 · S/N 2136 N95BLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2030 N960ASNolan Aviation LLC · Dover, DEBuilt 2010 · S/N 408 N961MMImmi Aviation LLC · Westfield, INS/N 356 N975DMSan LLC · Knoxville, TNBuilt 2007 · S/N 2073 N977RJR J Corman Aviation Services LLC · Nicholasville, KYBuilt 2014 · S/N 478 N979PREt Holdings LLC · Little Rock, ARBuilt 2016 · S/N 536 N97EJAir Echo LLC · Westlake, OHBuilt 2008 · S/N 2095 N984BHNew Marcos Investments II LLC · Houston, TXBuilt 2013 · S/N 469 N984XRFarm Leasing C Inc · Atlanta, INBuilt 2008 · S/N 373 N986BLWalmart Inc · Bentonville, ARS/N 449 N988MCCreamer Pilot Services LLC · Fayetteville, ARBuilt 2007 · S/N 352 N988RCMoyle Petroleum Co · Rapid City, SDBuilt 2001 · S/N 190 N98QCJ Bros LLC · Madison, WIS/N 603 N98QQSnider Aviation LLC · Marshall, TXBuilt 2015 · S/N 2146 N990EMAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2000 · S/N 086 N990WARa Aviation Holdings LLC · Prosper, TXBuilt 2009 · S/N 2122 N998ALJhl Management LLC · Bridgeport, NYS/N 592 N998NJNorthern Jet Management Inc · Grand Rapids, MIBuilt 2011 · S/N 2130 N999LBSpeedbird Inc · Cincinnati, OHBuilt 2013 · S/N 460

Back to AD 2005-24-13