Registered aircraft · 293

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:2001-17-26-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:2001-17-26-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:2001-17-26-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:2001-17-26-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:2001-17-26-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:2001-17-26-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.

N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628 N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524 N444JFBod Aviation LLC · Los Angeles, CABuilt 1999 · S/N 258431 N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573 N44UNHawker 258359 LLC · Dover, DEBuilt 1998 · S/N 258359 N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635 N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662 N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451 N475RSRomeo Sierra LLC · Morgantown, WVBuilt 2004 · S/N 258674 N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280 N488AMByte Me Transportation Inc · Fort Pierce, FLBuilt 2003 · S/N 258648 N489BMEd Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258271 N492DYLerma Aviation LLC · Dallas, TXBuilt 2001 · S/N 258546 N499PANe Charters LLC · South Jordan, UTBuilt 2005 · S/N 258739 N500XPHawker 800xp LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258455 N50KLLiberty Leasing V LLC · Melbourne, FLBuilt 2004 · S/N 258671 N511JCIntermodal Air LLC · Frankfort, ILBuilt 2001 · S/N 258518 N512JCCarr Air LLC · Cornelius, NCBuilt 2001 · S/N 258556 N512WCCarr Air LLC · Cornelius, NCBuilt 2002 · S/N 258595 N513BEH800 IV LLC · Stuart, FLBuilt 2000 · S/N 258471 N516THHippo Air LLC · Grants Pass, ORBuilt 1999 · S/N 258418 N521JKSale Reported · Beverly Hills, CASale reported, canceledBuilt 1994 · S/N 258262 N528MXCombined LLC · Helena, MTBuilt 2005 · S/N 258725 N540KTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2005 · S/N 258702 N541XPJoveros Aviation LLC · Miami, FLBuilt 2001 · S/N 258541 N544LRAviation Dynamics LLC · South Portland, MEBuilt 1994 · S/N 259044 N544PSLucas Aviation LLC · Fremont, MIBuilt 2000 · S/N 258491 N547LRAviation Dynamics LLC · Portland, MEBuilt 1994 · S/N 259047 N548LRAviation Dynamics LLC · South Portland, MEBuilt 1995 · S/N 259048 N552MEN552me LLC · Las Vegas, NVBuilt 2000 · S/N 258459 N553BWHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258570 N55BAKarma55ba LLC · Stuart, FLS/N 258356 N55LBPie High LLC · Atlanta, GABuilt 2000 · S/N 258494 N55XPAtlas Leasing Partners LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258583 N565SKM&N Equipment LLC · Englewood, COBuilt 2002 · S/N 258604 N569HADe Paz Aviation LLC · Coral Gables, FLS/N 258773 N5734N5734 LLC · Katy, TXBuilt 1997 · S/N 258304 N578RLValiair Limited Co Trustee · Casper, WYBuilt 1999 · S/N 258397 N585VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258585 N58DHAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2002 · S/N 258599 N595PDRegistration Pending · Camden, DERegistration pendingBuilt 2001 · S/N 258526 N606WJHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258606 N621SBHundredfold Seraphim LLC · Miami Lakes, FLBuilt 2001 · S/N 258531 N63YMSun Country Products LLC · Tampa, FLBuilt 2003 · S/N 258636 N64HAJoe Air LLC · Sellersburg, INBuilt 1999 · S/N 258448 N655MDMargarita Flights LLC · Longwood, FLBuilt 2004 · S/N 258655 N667WJConnell Blue LLC · Berkeley Heights, NJBuilt 2004 · S/N 258667 N66ZBCharter Equipment Leasing LLC · Bellevue, WABuilt 2004 · S/N 258675 N676GHNoll Air LLC · Orlando, FLBuilt 2004 · S/N 258676 N681SCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2000 · S/N 258502

Back to AD 2001-17-26 R1