OpenAirDocs.org
AD 2003-03-21

Registered aircraft · 534

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

N842AAstec Industries Inc · Chattanooga, TNBuilt 1999 · S/N 560-5042N843JSFe Encore Plus II LLC · Kinston, NCBuilt 2003 · S/N 560-5343N844JSFe5344 LLC · Kinston, NCBuilt 2003 · S/N 560-5344N845ATApalach Adventures LLC · Chattanooga, TNBuilt 2000 · S/N 560-0547N845JSThese Pretzels Are Making Me Thirsty LLC · Kinston, NCBuilt 2001 · S/N 560-5180N846JSChinaberry Landing LLC · Sugar Hill, GABuilt 2003 · S/N 560-5355N847A8m Holdings LLC · Bloomfield, NEBuilt 1999 · S/N 560-5047N847JSJml Jet II LLC · Uvalde, TXBuilt 2003 · S/N 560-5320N851HSCp Expansion 2 LLC · Little Rock, ARBuilt 2002 · S/N 550-1028N851JSFe Xl 5111 LLC · Kinston, NCBuilt 2000 · S/N 560-5111N852JSFe Xls 5566 LLC · Kinston, NCBuilt 2005 · S/N 560-5566N853JSFe Encore Plus I LLC · Kinston, NCBuilt 2003 · S/N 560-5352N855JSFe 5064 LLC · Kinston, NCBuilt 2000 · S/N 560-5064N856ACVision Jet LLC · Fort Wayne, INBuilt 2004 · S/N 560-0656N856JSFe 5040 LLC · Kinston, NCBuilt 1999 · S/N 560-5040N860JST&E Aviation LLC · Albuquerque, NMBuilt 2001 · S/N 560-5154N864HABravo Preferred Partners LLC · Solon, OHBuilt 1999 · S/N 550-0864N865JSFe 5283 LLC · Kinston, NCBuilt 2002 · S/N 560-5283N867JSJs Jet III LLC · Kinston, NCBuilt 2002 · S/N 560-5292N868JSEverything Aviation LLC · Trabuco Canyon, CABuilt 2001 · S/N 560-5152N868XLWhiskey Delta Bravo LLC · Fort Myers, FLBuilt 2005 · S/N 560-5603N869JSExclusive Jets LLC · Kinston, NCBuilt 2001 · S/N 560-5159N86WUUmphrey Air LLC · Beaumont, TXBuilt 2001 · S/N 560-5198N870BTdc Transportation LLC · Sylvania, OHS/N 550-0870N871RFScheels All Sports Inc · Fargo, NDBuilt 2001 · S/N 560-5219N872BBStampede Aviation LLC · Phoenix, AZBuilt 2004 · S/N 560-5515N872JSSea Jay LLC · Raleigh, NCBuilt 2002 · S/N 560-5302N875JSDcgt LLC · Fort Myers, FLBuilt 2006 · S/N 560-5658N876JATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 560-5048N876RAParminter Investments LLC · Wilmington, DEBuilt 2002 · S/N 560-5231N878CHBruce Alexander Company LLC · Elkhart, INBuilt 2003 · S/N 550-1067N87NSSeaman Corporation · Wooster, OHBuilt 2001 · S/N 560-5213N87SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 560-0616N87WUBarristair Lc · Beaumont, TXBuilt 1999 · S/N 560-5039N880POp Aviation LLC · Seattle, WABuilt 2004 · S/N 560-5364N882WFSotex II LLC · Midland, TXBuilt 1999 · S/N 550-0882N883SCBuffalo Bayou Air LLC · Houston, TXBuilt 2000 · S/N 560-5124N884BFriendly Skies 2 LLC · Muncie, INBuilt 2001 · S/N 560-5140N884RCJannenga Air LLC · Phoenix, AZBuilt 2001 · S/N 560-0552N886YSTs Sky LLC · Sellersburg, INBuilt 2002 · S/N 550-1013N887WPPack Force One LLC · Raleigh, NCBuilt 2001 · S/N 560-5147N888GDCluheir LLC · Van, TXBuilt 2002 · S/N 560-0634N888WDEagles Wings Holdings II LLC · Canfield, OHBuilt 2004 · S/N 550-1097N88HPNlp Leasing LLC · North Adams, MABuilt 1999 · S/N 560-5050N89MDFuturesource Capital Corp · Bismarck, NDBuilt 2002 · S/N 560-0612N89PR603 Holdings LLC · Aberdeen, SDBuilt 2002 · S/N 560-0603N8JWWatkins Construction Company LLC · Corsicana, TXBuilt 2002 · S/N 560-5305N900KDThird Rockmar LLC · Denton, TXBuilt 2004 · S/N 560-5523N900TVN900tx LLC · Austin, TXBuilt 2000 · S/N 560-5097N901CRCxlo Enterprises LLC · Cincinnati, OHBuilt 2001 · S/N 560-5141
Back to AD 2003-03-21